| Author |
Message |
 Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 27, 2023 12:56 am Subject: SQL Server Store proc error |
Hmm it might be worth trying EXTERNAL NAME "dbo.claimsProc"; in the ESQL definition Was right here  |
| Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 27, 2023 12:51 am Subject: SQL Server Store proc error |
The issue is resolved by IBM PMR the :
EXTERNAL NAME "dbo.claimsProc"; should be used instead of EXTERNAL NAME "CMS.dbo.claimsProc";
but for sql query i have used SET INSE ... |
| Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 18, 2023 2:44 am Subject: SQL Server Store proc error |
Fyi: Character datatype also give me same error.
As recommended I will reach to IBM PMR team. Will keep the link posted on the progress. |
| Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 17, 2023 7:22 am Subject: SQL Server Store proc error |
Thanks for your input I have tried those before coming to the forum
normal insert statement is working fine with (CMS.dbo.CLM_HDR_CURR):
SET INSERT_CLAIMS = 'INSERT INTO CMS.dbo.CLM_HDR_CURR ... |
| Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 17, 2023 4:35 am Subject: SQL Server Store proc error |
As the java code says (java.sql.Timestamp)ts
i use:
SET ts = '1983-07-12 21:30:55.888';
Still the error is same. |
| Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 17, 2023 4:30 am Subject: SQL Server Store proc error |
SQL proc:
Code:
USE
I also did the following change but the error is same
DECLARE ts TIMESTAMP;-- CURRENT_TIMESTAMP;
SET ts = '1983-07-12 21:30:55';
CALL callSt ... |
| Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 17, 2023 3:20 am Subject: Existing Java Code |
This is the existing Java code which is running for last 6 yr that i am replacing with ACE esql. it might help in analysis the same stored proc is called here call CMS.dbo.claimsProc
package cla ... |
| Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 17, 2023 2:32 am Subject: SQL Server Store proc error |
SQL proc:
USE [CMS]
GO
/****** Object: StoredProcedure [dbo].[claimsProc] Script Date: 7/17/2023 6:29:12 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTE ... |
| Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jul 16, 2023 10:50 pm Subject: SQL Server Store proc error |
Thanks team for looking into my issue
fjb_saper
Possibly passing a string and not a timestamp to the proc?
ts is in timestamp format:
ts:TIMESTAMP:java.util.GregorianCalendar[ ... |
| Topic: SQL Server Store proc error |
ata_nitjsr
Replies: 15
Views: 34456
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jul 16, 2023 6:48 am Subject: SQL Server Store proc error |
I am trying to call a SQL server stored proc, Which return me an integer by taking time stamp as an input.
I am getting an error of procedure not found any help is apricated
Store proc d ... |
| Topic: Debug not attaching |
ata_nitjsr
Replies: 3
Views: 4079
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 09, 2023 10:57 pm Subject: Solved!! |
| Program has stopped the access of non-secure port from application without informing. Telnet was kept open but some policy was put in to close access from application. So it created the issue. Got an ... |
| Topic: Debug not attaching |
ata_nitjsr
Replies: 3
Views: 4079
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Feb 08, 2023 12:45 pm Subject: Debug not attaching |
i have request to the support team for the event Logs.
Yes User Traces is a option which we are using now. |
| Topic: Debug not attaching |
ata_nitjsr
Replies: 3
Views: 4079
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Feb 07, 2023 8:47 pm Subject: Debug not attaching |
I am facing a problem where IIB Debug tool is getting started the progress bar goes to 27% and then get canceled. Telnet to the debug port is working fine.
FYI: on netstat -an|grep portno on the b ... |
| Topic: Generate file from BASE64encoded payload |
ata_nitjsr
Replies: 2
Views: 3288
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 23, 2017 11:21 am Subject: Resolved:Generate file from BASE64encoded payload |
The issue is resolved:
SET BLOB_Payload = BASE64DECODE(refBO.*:payLoad);
SET OutputRoot.BLOB.BLOB = BLOB_Payload;
|
| Topic: Generate file from BASE64encoded payload |
ata_nitjsr
Replies: 2
Views: 3288
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 23, 2017 9:15 am Subject: Generate file from BASE64encoded payload |
I have base64 encoded message of a pdf file. I need to generate the pdf file.
Following is the code I am using:
SET BLOB_Payload= BASE64DECODE(refBO.*:payLoad);
CREATE FIELD OutputR ... |
