| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| UGT: function PASSTHRU not fully working |
« View previous topic :: View next topic » |
| Author |
Message
|
| Manuel_ch |
 Posted: Wed Jul 27, 2005 8:22 am Post subject: UGT: function PASSTHRU not fully working |
 |
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
I have just re-install my win2000 server where the config manager of wmqi 2.1 is configure and my old flows doesn't working anymore.
To be precise the function PASSTHRU failed:
the original code is :
PASSTRHU('INSERT INTO EAI_ARCHIVAGE (
IDARCHIVAGE,
IDLOT,
ORDERID,
LOGINUSER,
FLOWNAME,
SENDINGAPPLICATION,
MESSAGETYPE,
EVENTDATE,
SENDINGDATE,
FLOWDATE,
CHANGINGDATE,
QMANAGER,
QNAME,
LASTSUBMITDATE,
SUBMITNUMBER,
ERRORCODE,
ERRORTEXT,
ERRORNODE,
BUFFERXML,
HISTORY)
VALUES (?, ?, ?, ?, ?, ?, ?, TO_DATE( ?, ?), TO_DATE( ?,?), TO_DATE( ?, ?), TO_DATE( ?, ?), ?, ?, TO_DATE( ?, ?), ?, ?, ?, ?, ?, ?)',....);
this code return the error :
'[DataDirect][ODBC Oracle driver]Invalid character value. Error in parameter 10.'
This code still working on others environnements.
I changed all the TO_DATE(?,?) by the value marked in the trace : TO_DATE('20/08/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS') and it's working perfectly.
Then I tried changing TO_DATE(?,?) by TO_DATE(''?'',''?'') or TO_DATE(?,''?'') and the error : "Invalid Descriptor index" appears.
Is it a question of patch? mine is CSD03.
The server which is executing this code haven't been re-install and is on AIX server. I've just delete and recreate the broker on it.
Thx
Manuel |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Jul 27, 2005 8:27 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
So, TO_DATE is an SQLServer function that takes a date value and a date format string.
Are you positive that you are passing it the correct parameter each time?
What value is the 10th one you are passing to Values?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Wed Jul 27, 2005 8:46 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
I'm positive of what in all the parameters, I've just copy the values from the trace file :
see by yourself :
with parameters '16355, NULL, '1234', 'EAIMCHE', 'F_EC9', 'Nabucco', 'CREATION_ECRITURE', '22/07/2005 07:36:38', 'DD/MM/YYYY HH24:MI:SS', '22/07/2005 07:50:35', 'DD/MM/YYYY HH24:MI:SS', '2005-07-22 07:50:35', 'DD/MM/YYYY HH24:MI:SS', '01/01/2001 12:00:00', 'DD/MM/YYYY HH24:MI:SS', 'QM_EAI_1_DEV', 'Q_NABU.F_EC', '2005-07-25 10:00:01', 'DD/MM/YYYY HH24:MI:SS', NULL, '0', ...
During my tests, I improve the notion of parameter 10:
-I transforme all the TO_DATE(?,?) by the value except the last TO_DATE.
-Then all TO_DATE(?,?) by the value except the first one.
->And each time the error message was 'Error in Parameter 10' and the TO_DATE parameter wasn't each time at the same position.
Very strange!
Is there a maximum number of parameter? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Jul 27, 2005 8:56 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Can you enable tracing in SQL server, and see what it thinks the query is?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Wed Jul 27, 2005 11:11 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
| How can I activate trace on Oracle 8i Database? |
|
| Back to top |
|
|
| JT |
| Posted: Wed Jul 27, 2005 3:27 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| with parameters '16355, NULL, '1234', 'EAIMCHE', 'F_EC9', 'Nabucco', 'CREATION_ECRITURE', '22/07/2005 07:36:38', 'DD/MM/YYYY HH24:MI:SS', '22/07/2005 07:50:35', 'DD/MM/YYYY HH24:MI:SS', '2005-07-22 07:50:35', 'DD/MM/YYYY HH24:MI:SS', '01/01/2001 12:00:00', 'DD/MM/YYYY HH24:MI:SS', 'QM_EAI_1_DEV', 'Q_NABU.F_EC', '2005-07-25 10:00:01', 'DD/MM/YYYY HH24:MI:SS', NULL, '0', ... |
The hilighted values are not in the proper format. It should be either:
| Quote: |
| '2005-07-22 07:50:35', 'YYYY-MM-DD HH24:MI:SS', |
or
| Quote: |
| '22/07/2005 07:50:35', 'DD/MM/YYYY HH24:MI:SS', |
|
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Wed Jul 27, 2005 11:23 pm Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
Sorry, I didn't post the right log.
See above one of my test with only one TO_DATE(?,?) with the same consequence :
| Quote: |
The following error occurred during execution of a database SQL statement against datasource 'DSN_CFG'. The SQL statement was 'INSERT INTO EAI_ARCHIVAGE (
IDARCHIVAGE,
IDLOT,
ORDERID,
LOGINUSER,
FLOWNAME,
SENDINGAPPLICATION,
MESSAGETYPE,
EVENTDATE,
SENDINGDATE,
FLOWDATE,
CHANGINGDATE,
QMANAGER,
QNAME,
LASTSUBMITDATE,
SUBMITNUMBER,
ERRORCODE,
ERRORTEXT,
ERRORNODE,
BUFFERXML,
HISTORY)
VALUES (?, ?, ?, ?, ?, ?, ?, TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'), TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'), TO_DATE( '2005-07-27 10:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'),
?, ?, TO_DATE( ?, ?), ?, ?, ?, ?, ?, ?)'. The parameters passed were '16364, NULL, '1234', 'EAIMCHE', 'F_EC9', 'Nabucco', 'CREATION_ECRITURE', 'QM_EAI_1_DEV', 'Q_NABU.F_EC', '25/07/2005 10:00:01', 'DD/MM/YYYY HH24:MI:SS', NULL, '0', '[DataDirect][ODBC Oracle driver]Invalid descriptor index.', 'FL_Archivage.C_InsDB_EAI_ARCHIVAGE', '<Fournisseur>...</Fournisseur>', 'M. Jackson', '.
2005-07-27 15:45:29.926561 2314 DatabaseException BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
2005-07-27 15:45:29.926582 2314 DatabaseException BIP2322E: Database error: SQL State '22018'; Native Error Code '0'; Error Text '[DataDirect][ODBC Oracle driver]Invalid character value. Error in parameter 10.'.
The error has the following diagnostic information: SQL State '22018' SQL Native Error Code '0' SQL Error Text '[DataDirect][ODBC Oracle driver]Invalid character value. Error in parameter 10.'
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error. |
and a other test with only one TO_DATE but not in the same position :
| Quote: |
The following error occurred during execution of a database SQL statement against datasource 'DSN_CFG'. The SQL statement was 'INSERT INTO EAI_ARCHIVAGE (
IDARCHIVAGE,
IDLOT,
ORDERID,
LOGINUSER,
FLOWNAME,
SENDINGAPPLICATION,
MESSAGETYPE,
EVENTDATE,
SENDINGDATE,
FLOWDATE,
CHANGINGDATE,
QMANAGER,
QNAME,
LASTSUBMITDATE,
SUBMITNUMBER,
ERRORCODE,
ERRORTEXT,
ERRORNODE,
BUFFERXML,
HISTORY)
VALUES (?, ?, ?, ?, ?, ?, ?, TO_DATE( ?, ?), TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'), TO_DATE( '2005-07-27 10:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'),
?, ?, TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'), ?, ?, ?, ?, ?, ?)'. The parameters passed were '16367, NULL, '1234', 'EAIMCHE', 'F_EC9', 'Nabucco', 'CREATION_ECRITURE', '22/07/2005 07:36:38', 'DD/MM/YYYY HH24:MI:SS', 'QM_EAI_1_DEV', 'Q_NABU.F_EC', NULL, '0', '[DataDirect][ODBC Oracle driver]Invalid character value. Error in parameter 10.', 'FL_Archivage.C_InsDB_EAI_ARCHIVAGE', '<Fournisseur>...</Fournisseur>', 'M. Jackson', '.
2005-07-27 17:32:59.417739 2314 DatabaseException BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
2005-07-27 17:32:59.417770 2314 DatabaseException BIP2322E: Database error: SQL State '22018'; Native Error Code '0'; Error Text '[DataDirect][ODBC Oracle driver]Invalid character value. Error in parameter 10.'.
The error has the following diagnostic information: SQL State '22018' SQL Native Error Code '0' SQL Error Text '[DataDirect][ODBC Oracle driver]Invalid character value. Error in parameter 10.'
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
|
I am pretty sure of what is attempt to be insert is correct. |
|
| Back to top |
|
|
| Ian |
| Posted: Thu Jul 28, 2005 5:06 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Manuel,
The key here is what data is in parameter 10. This is somewhat unclear.
Certainly, in your example, your have not highlighted the 10th parameter, but the 8th and 9th parameters ...
| Quote: |
VALUES (?, ?, ?, ?, ?, ?, ?, TO_DATE( ?, ?), TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'), TO_DATE( '2005-07-27 10:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'),
?, ?, TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'), ?, ?, ?, ?, ?, ?)'. The parameters passed were '16367, NULL, '1234', 'EAIMCHE', 'F_EC9', 'Nabucco', 'CREATION_ECRITURE', '22/07/2005 07:36:38', 'DD/MM/YYYY HH24:MI:SS', 'QM_EAI_1_DEV', 'Q_NABU.F_EC', NULL, '0', '[DataDirect][ODBC Oracle driver]Invalid character value. Error in parameter 10.', 'FL_Archivage.C_InsDB_EAI_ARCHIVAGE', '<Fournisseur>...</Fournisseur>', 'M. Jackson', '.
|
What WMQI version and level are you running with ?
What is the table definition for the table you are inserting into ?
_________________
Regards, Ian |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Thu Jul 28, 2005 5:37 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
The version of my WMQI is 2.1 CSD 03
The table definition is :
| Quote: |
CREATE TABLE EAI_ARCHIVAGE (
IDARCHIVAGE NUMBER (12) NOT NULL,
ORDERID NUMBER (20) NOT NULL,
LOGINUSER VARCHAR2 (50) NOT NULL,
FLOWNAME VARCHAR2 (50) NOT NULL,
SENDINGAPPLICATION VARCHAR2 (50) NOT NULL,
MESSAGETYPE VARCHAR2 (50) NOT NULL,
EVENTDATE DATE NOT NULL,
SENDINGDATE DATE,
FLOWDATE DATE,
QMANAGER VARCHAR2 (100),
QNAME VARCHAR2 (100),
CHANGINGDATE DATE,
LASTSUBMITDATE DATE,
SUBMITNUMBER NUMBER (12),
ERRORCODE NUMBER (6),
ERRORTEXT VARCHAR2 (2000),
ERRORNODE VARCHAR2 (100),
BUFFERXML CLOB,
IDLOT NUMBER (12),
HISTORY VARCHAR2 (2000),
CONSTRAINT PK_UNIQUE_ARCH_NEW
UNIQUE (IDARCHIVAGE),
CONSTRAINT PK_CLE_PRIMAIRE_ARCH_NEW
PRIMARY KEY ( IDARCHIVAGE )
USING INDEX
TABLESPACE WLCS_DATA PCTFREE 10
STORAGE ( INITIAL 20480 NEXT 40960 PCTINCREASE 50 ))
TABLESPACE WLCS_DATA
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 20480
NEXT 6545408
PCTINCREASE 50
MINEXTENTS 1
MAXEXTENTS 249
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
|
An other element is that this same code, and the same DB structure was working perfectly before and is still working in 3 others environments. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Jul 28, 2005 5:43 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Just on a whim, try the same insert without any of the dates at all (not even hardcoded dates - remove the date fields entirely).
Also, what do you mean by "other environments"? Do you mean other installations of 2.1 CSD 3 talking to the same level of oracle supporting the same table?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Ian |
| Posted: Thu Jul 28, 2005 7:05 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
My initial thoughts when I saw this was that "[DataDirect][ODBC Oracle driver]Invalid character value" suggests a known problem.
Details as follows :
| Code: |
Merant Case # 1276604 : database exception 'invalid character value' thrown when a character string inserted into an Oracle VARCHAR2 datatype and the format of the data is 'number-number-number ...'
WMQIv2.1.0 CSD02 -> shipped with the Merant 3.7 driver -> MERANT 3.70 Oracle8 Driver
WMQIv2.1.0 CSD03 -> shipped with the Merant 3.7 driver + fixes -> MERANT 3.70 Oracle8 Driver
WMQIv2.1.0 CSD05 -> shipped with the Merant 4.1 driver -> MQSeries DataDirect Technologies 4.10 32-BIT Oracle Driver
The 3.7 driver supplied with CSD03 and the 4.1 driver supplied in CSD05 included a collection of Merant Oracle driver fixes.
Merant Case # 1276604 was fixed as part of this collection.
Suggest you ensure you are running at WMQIv2.1.0 CSD03 or above AND using the new drivers.
|
However, it is not clear that parameter 10 actually matches up to parameter containing the date with the format 'number-number-number ...', ie '2005-07-27 10:00:00'.
Also, the matching column type is defined as DATE.
A few further questions ...
- Is the WMQI broker running on Windows or AIX ? (It is unclear from your previous comments as to whether the broker or database server was on AIX)
- If the WMQI broker is on AIX then lets see your .odbc.ini file ?
- If the WMQI broker is on Windows then check which driver you are using by looking in the "ODBC Data Source Administrator"
- What CSD level is the broker running under ?
- What version of Oracle client have you got installed in the broker environment ?
Following this I would suggest you perform some comparative analysis on your working and failing environments looking at ...
- WMQI version and level
- What Merant driver is being used
- Data being inserted (and the format of the data), use WMQI User traces
- Compare table definitions for EAI_ARCHIVAGE
- Compare ODBC traces checking the source and target datatypes
And then if still not resolved then to open a PMR with IBM Support.
One further note, WMQI v2.1 CSD03 is pretty old (and as you can see from above the interface between WMQI and Oracle has changed in v2.1 CSD releases as there were problems).
PS, jefflowery, your approach is on the right track (as ususal).
_________________
Regards, Ian |
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Thu Jul 28, 2005 7:08 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
I've made the test :
Changing the table structure to accept null in date fields.
In the passthru function delete all date insertion.
It's working fine: the line have been succesfully inserted.
here the log
| Quote: |
2005-07-28 16:51:28.953727 2321 UserTrace BIP2544I: Node 'FL_Archivage.C_InsDB_EAI_ARCHIVAGE': Executing database SQL statement 'INSERT INTO EAI_ARCHIVAGE (
IDARCHIVAGE,
IDLOT,
ORDERID,
LOGINUSER,
FLOWNAME,
SENDINGAPPLICATION,
MESSAGETYPE,
QMANAGER,
QNAME,
SUBMITNUMBER,
ERRORCODE,
ERRORTEXT,
ERRORNODE,
BUFFERXML,
HISTORY)
VALUES (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?)' derived from (72, 1); expressions 'nIdArchi, nIdLotArchi, InputBody.Siprog.MsgEntry.Header.OrderId, sLoginUser, InputBody.Siprog.MsgEntry.Header.FlowName, InputBody.Siprog.MsgEntry.Header.SendingApp, InputBody.Siprog.MsgEntry.Header.MessageType, InputBody.Siprog.MsgEntry.Header.QueueManagerName, InputBody.Siprog.MsgEntry.Header.QueueName, InputBody.Siprog.MsgEntry.Header.SubmitNumber, InputBody.Siprog.MsgEntry.Header.Error.Code, InputBody.Siprog.MsgEntry.Header.Error.Text, InputBody.Siprog.MsgEntry.Header.Error.Node, sContent, InputBody.Siprog.MsgEntry.Header.History'; resulting parameter values '16379, NULL, '1234', 'EAIMCHE', 'F_EC9', 'Nabucco', 'CREATION_ECRITURE', 'QM_EAI_1_DEV', 'Q_NABU.F_EC', NULL, '0', '', '', '<Fournisseur>…< Fournisseur>', 'M. Jackson''.
2005-07-28 16:51:29.006092 2321 UserTrace BIP4124I: Message propagated to 'out' terminal of compute node 'FL_Archivage.C_InsDB_EAI_ARCHIVAGE'.
|
|
|
| Back to top |
|
|
| JT |
| Posted: Thu Jul 28, 2005 7:24 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Ian wrote: |
| However, it is not clear that parameter 10 actually matches up to parameter containing the date with the format 'number-number-number ...', ie '2005-07-27 10:00:00'. |
| Code: |
1. IDARCHIVAGE, ?, '16364,
2. IDLOT, ?, NULL,
3. ORDERID, ?, '1234',
4. LOGINUSER, ?, 'EAIMCHE',
5. FLOWNAME, ?, 'F_EC9',
6. SENDINGAPPLICATION, ?, 'Nabucco',
7. MESSAGETYPE, ?, 'CREATION_ECRITURE',
8. EVENTDATE, TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'),
9. SENDINGDATE, TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'),
10. FLOWDATE, TO_DATE( '2005-07-27 10:00:00', 'YYYY-MM-DD HH24:MI:SS'),
11. CHANGINGDATE, TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'),
12. QMANAGER, ?, 'QM_EAI_1_DEV',
13. QNAME, ?, 'Q_NABU.F_EC',
14. LASTSUBMITDATE, TO_DATE( ?, ?), '25/07/2005 10:00:01', 'DD/MM/YYYY HH24:MI:SS',
15. SUBMITNUMBER, ?, NULL,
16. ERRORCODE, ?, '0',
17. ERRORTEXT, ?,
18. ERRORNODE, ?,
19. BUFFERXML, ?,
20. HISTORY) ? |
|
|
| Back to top |
|
|
| Manuel_ch |
| Posted: Thu Jul 28, 2005 7:36 am Post subject: |
|
|
Apprentice
Joined: 27 Jul 2005
Posts: 31
|
The architecture:
Windows 2000
-MQSeries (queue for configmgr,channel to AIX)
-DB2 7.1 (DB for config mgr and DB for messages)
-WMQI (configmgr) CSD 05 (I've just upgrade it without any change)
on AIX 4.3.3:
-MQSeries (all the queues)
-WMQI (broker) CSD?? (how can I see it?)
-Oracle client 817
on a 2nd AIX
-DB Oracle MQS521 used as DB for Broker
Note: we are trying to insert a line in this same DB
Only the Windows server have been fully reinstall.
The broker in AIX server have been delete and recreate.
Question:
Is there a special method to delete the broker : I did mqsideletebroker MYBROKER. Has the MQS521 been cleared? Does the MQS521 have to be clean?
here, a extract of my odbc.ini:
| Quote: |
[ODBC Data Sources]
MQSIBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
TNS_MQS521=DataDirect 410 Oracle 8 Driver
ORACLEDB=DataDirect 410 Oracle 8 Driver
DSN_CFG=DataDirect 410 Oracle 8 Driver
DSN_BRK=DataDirect 410 Oracle 8 Driver
MQS521=DataDirect 410 Oracle 8 Driver
[MQSIBKDB]
Driver=/u/db2inst1/sqllib/lib/db2.o
Description=MQSIBKDB DB2 ODBC Database
Database=MQSIBKDB
[MYDB]
Driver=/u/db2inst1/sqllib/lib/db2.o
Description=MYDB DB2 ODBC Database
Database=MYDB
[TNS_MQS521]
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=TNS_MQS521
EnableDescribeParam=1
OptimizePrepare=1
[MQS521]
QEWSD=38555
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=MQS521
EnableDescribeParam=1
OptimizePrepare=1
[DSN_CFG]
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=MQS521
EnableDescribeParam=1
OptimizePrepare=1
[DSN_BRK]
QEWSD=37608
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=MQS521
EnableDescribeParam=1
OptimizePrepare=1
[ORACLEDB]
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=YourServerName
EnableDescribeParam=1
OptimizePrepare=1
[ODBC]
Trace=0
TraceFile=/var/wmqi/odbc/odbctrace.out
TraceDll=/usr/opt/wmqi/merant/lib/odbctrac.so
InstallDir=/usr/opt/wmqi/merant
|
|
|
| Back to top |
|
|
| Ian |
| Posted: Thu Jul 28, 2005 7:40 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
And the other one looked something like ... but still reported parameter 10.
| Code: |
1. IDARCHIVAGE, ?, '16364,
2. IDLOT, ?, NULL,
3. ORDERID, ?, '1234',
4. LOGINUSER, ?, 'EAIMCHE',
5. FLOWNAME, ?, 'F_EC9',
6. SENDINGAPPLICATION, ?, 'Nabucco',
7. MESSAGETYPE, ?, 'CREATION_ECRITURE',
8. EVENTDATE, TO_DATE( ?, ?), '25/07/2005 10:00:01', 'DD/MM/YYYY HH24:MI:SS',
9. SENDINGDATE, TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'),
10. FLOWDATE, TO_DATE( '2005-07-27 10:00:00', 'YYYY-MM-DD HH24:MI:SS'),
11. CHANGINGDATE, TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'),
12. QMANAGER, ?, 'QM_EAI_1_DEV',
13. QNAME, ?, 'Q_NABU.F_EC',
14. LASTSUBMITDATE, TO_DATE( '27/07/2005 10:00:00', 'DD/MM/YYYY HH24:MI:SS'),
15. SUBMITNUMBER, ?, NULL,
16. ERRORCODE, ?, '0',
17. ERRORTEXT, ?,
18. ERRORNODE, ?,
19. BUFFERXML, ?,
20. HISTORY) ? |
_________________
Regards, Ian |
|
| Back to top |
|
|
|
|
|
  |
Goto page 1, 2 Next |
Page 1 of 2 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
