My Oracle Support Banner

Tuxedo ART DSNUTILB Wrong Data Conversion With Nullable Columns (Doc ID 2356149.1)

Last updated on JULY 24, 2018

Applies to:

Oracle Tuxedo Application Runtime for CICS and Batch - Version 12.2.2 and later
Information in this document applies to any platform.

Goal

User encountered the following error while using dsnutilb:

[DSNUTILB]: [20171219 17:33:56.829256]: [ERROR]: [check_db_err] OCI_ERROR - ORA-00917: missing comma
[DSNUTILB]: [20171219 17:33:56.831531]: [DUMP]: [load_parseRecord] CHAR, colvalue=[0000]
[DSNUTILB]: [20171219 17:33:56.836418]: [DUMP]: [check_db_err] End. Check DB error.
[DSNUTILB]: [20171219 17:33:56.839374]: [ERROR]: [execSQLSTMT] Failed to execute SQL(insert into XXXXXXXXXXXXX(XXXXXXXXXXXXXXX,...,XXXXXXXXXX,XXXXX,XXXXXXXXXX) values('   ','YYYYYYY','0000','   ','YYYYYYY',TO_DATE('06.09.2016', 'DD.MM.YYYY'),'KO',TO_TIMESTAMP('2017-08-25-00.41.19.195635','YYYY-MM-DD-HH24.MI.SS.FF6'),'YYYYYYYYYY',-000000000000000000<3,TO_TIMESTAMP('                         ?','YYYY-MM-DD-HH24.MI.SS.FF6'),-00000000000000<3,TO_TIMESTAMP('YYYYYYYYYYYYYYYYYYYYYYYYYY','YYYY-MM-DD-HH24.MI.SS.FF6'))). rc=-1, errode= 917, errmsg = Error - ORA-00917: missing comma
[DSNUTILB]: [20171219 17:33:56.851453]: [ERROR]: [load_sqlThread] InsertThread[1]:Failed to execute INSERT statement(Record number=[1]).insertstmt=[insert into XXXX.XXXXXXXX(XXXXXXXXXXXXXXX,...,XXXXXXXXXX) values('   ','YYYYYYY','0000','   ','YYYYYYY',TO_DATE('06.09.2016', 'DD.MM.YYYY'),'KO',TO_TIMESTAMP('2017-08-25-00.41.19.195635','YYYY-MM-DD-HH24.MI.SS.FF6'),'YYYYYYYYYY',-000000000000000000<3,T



User believes wrong conversion by dsnutilb where there are nullable columns, and in user's above case the problem is with NUMBER and TIMESTAMP column type.
User wants to know whether nullable column is supported or not.

 

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.