Skip to Content
0
Former Member
Aug 29, 2007 at 07:31 AM

Redwood Help

42 Views

Hi All,

We are running script RSI_IMPORT_OUTPUT_DIVICESES to import SAP printers in Redwood and getting following error.

ORA-01400: cannot insert NULL into ("RSI"."RSI_SAP_PRINTERS"."TYPE")

ORA-06512: at "RSI.RSILIB", line 3254

ORA-06512: at "RSI.RSIEXEC", line 1118

ORA-06512: at "RSI.RSI_IMPORT_OUTPUT_DEVICES", line 15

ORA-06512: at "RSI.RSI_IMPORT_OUTPUT_DEVICES", line 38

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SYS_SQL", line 1200

ORA-06512: at "SYS.DBMS_SQL", line 323

ORA-06512: at "SYSJCS.DDL", line 552

ORA-06512: at "SYSJCS.DDL", line 585

ORA-06512: at "SYSJCS.DDL", line 639

ORA-06512: at line 3

JCS-00215: in statement RSOJ_EXECUTE_JOB

Here the child script RSI SEARCH_OUTPUT_DEVICE is searching all the devices successfully.

being a ABAPer, I am new to Oracle and can only sense that the value of the printer type is not getting passed. But I do not understand on how to proceed. Are we required to change the procedure (or whatever in Oracle..-:)). If yes how to change it...

tried to google something and found this thread...

http://www.thescripts.com/forum/thread64736.html

Thanks in advance for all your help and support.

Best Regards,

Vithalprasad