Skip to Content
0
Former Member
Oct 30, 2012 at 04:58 PM

CJS-00084 SQL statement or script failed.

91 Views

Can any body help me i have this error "CJS-00084" mentioned in sapinst.log

where it pointed to ora_sql_results.log

when i checked the oracle log file the last few lines looks like this

==============================================================

2012-10-30, 20:46:40 SAPINST ORACLE start logging for

@@ORADBUSR.SQL

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Oct 30 20:46:40 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Connected.

old 6: if length('&&1') = 5 then

new 6: if length('SAPSR3') = 5 then

old 7: if substr(upper('&&1'),1,5) = 'SAPR3' then

new 7: if substr(upper('SAPSR3'),1,5) = 'SAPR3' then

old 11: if upper('&&2') = 'NT' then

new 11: if upper('NT') = 'NT' then

old 18: :sDomain := upper('&&3');

new 18: :sDomain := upper('lordes-d96b62b4');

old 19: :sSapSid := upper('&&4');

new 19: :sSapSid := upper('DAN');

old 21: :sSapSid := upper('&&3');

new 21: :sSapSid := upper('lordes-d96b62b4');

old 37: :sSchema := upper('&&1');

new 37: :sSchema := upper('SAPSR3');

old 39: if upper('&&2') = 'NT' then

new 39: if upper('NT') = 'NT' then

old 46: :sDomain := upper('&&3');

new 46: :sDomain := upper('lordes-d96b62b4');

old 47: :sSapSid := upper('&&4');

new 47: :sSapSid := upper('DAN');

old 49: :sSapSid := upper('&&3');

new 49: :sSapSid := upper('lordes-d96b62b4');

Service username too long: max length is 30

O$LORDES-D96B62B4\SAPSERVICEDAN

begin

*

ERROR at line 1:

ORA-20000: Service username too long: max length is 30

ORA-06512: at line 23

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SAPINST: End of output of SQL executing program D:\oracle\product\10.2.0\db_2/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2012-10-30, 20:46:42 SAPINST ORACLE stop logging

what is the solution please help me and thanks in advance