Skip to Content
0

Loading of 'SAPVIEW' import package

Mar 13 at 10:15 PM

55

avatar image

Dear Expert,

I am installing SAP Solution Manager 7.2 on Sybase. during import ABAP I am facing issue in last package SAPVIEW. I have gone through so many posts herem but could not get any solution please help me to resolve the issue. SAPVIEW logs and sapinst_dev logs are attached.

(IMP) ERROR: DbSlExecute: rc = 99

(IMP) ERROR: (SYB) (SQL error 30273)

(IMP) ERROR: Error message returned by DbSl:

(IMP) ERROR: (SYB) SQL error = 30273

(IMP) ERROR: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(TSK) INFO: 0.00 rows/sec, 0.00 MB/sec

(TSK) ERROR: Finished create for object "VSEOMETHOD" of type "view" with error in 0 sec #20180314020259

(TSK) INFO: Starting create for object "VSEOOBJREL" of type "view" #20180314020259

(IMP) WARNING: Ignoring failed drop: (SYB) DDL statement failed

(IMP) WARNING: (DROP VIEW "VSEOOBJREL")

(IMP) WARNING: DbSlExecute: rc = 99

(IMP) WARNING: (SYB) (SQL error 30273)

(IMP) WARNING: Error message returned by DbSl:

(IMP) WARNING: (SYB) SQL error = 30273

(IMP) WARNING: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(IMP) ERROR: Task failed with error: (SYB) DDL statement failed

(IMP) ERROR: (CREATE VIEW "VSEOOBJREL" ( "CLSNAME" , "RELNAME" , "LANGU" , "AUTHOR" , "CREATEDON" , "CHANGEDBY" , "CHANGEDON" , "DESCRIPT" ) AS SELECT T0001."CLSNAME", T0001."RELNAME", T0002."LANGU", T0001."AUTHOR", T0001."CREATEDON", T0001."CHANGEDBY", T0001."CHANGEDON", T0002."DESCRIPT" FROM "SEORELCOMP" T0001, "SEORLCMPTX" T0002 WHERE T0001."CLSNAME" = T0002."CLSNAME" AND T0001."RELNAME" = T0002."RELNAME" AND T0001."RELCMPTYPE" = '2')

(IMP) ERROR: DbSlExecute: rc = 99

(IMP) ERROR: (SYB) (SQL error 30273)

(IMP) ERROR: Error message returned by DbSl:

(IMP) ERROR: (SYB) SQL error = 30273

(IMP) ERROR: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(TSK) INFO: 0.00 rows/sec, 0.00 MB/sec

(TSK) ERROR: Finished create for object "VSEOOBJREL" of type "view" with error in 0 sec #20180314020300

(TSK) INFO: Starting create for object "VSEOPARAM" of type "view" #20180314020300

(IMP) WARNING: Ignoring failed drop: (SYB) DDL statement failed

(IMP) WARNING: (DROP VIEW "VSEOPARAM")

(IMP) WARNING: DbSlExecute: rc = 99

(IMP) WARNING: (SYB) (SQL error 30273)

(IMP) WARNING: Error message returned by DbSl:

(IMP) WARNING: (SYB) SQL error = 30273

(IMP) WARNING: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(IMP) ERROR: Task failed with error: (SYB) DDL statement failed

(IMP) ERROR: (CREATE VIEW "VSEOPARAM" ( "CLSNAME" , "CMPNAME" , "SCONAME" , "VERSION" , "LANGU" , "DESCRIPT" , "CMPTYPE" , "MTDTYPE" , "EDITORDER" , "DISPID" , "AUTHOR" , "CREATEDON" , "CHANGEDBY" , "CHANGEDON" , "PARDECLTYP" , "PARPASSTYP" , "TYPTYPE" , "TYPE" , "TABLEOF" , "PARVALUE" , "PAROPTIONL" , "PARPREFERD" , "LOCKED" ) AS SELECT T0001."CLSNAME", T0001."CMPNAME", T0001."SCONAME", T0002."VERSION", T0003."LANGU", T0003."DESCRIPT", T0001."CMPTYPE", T0001."MTDTYPE", T0002."EDITORDER", T0002."DISPID", T0002."AUTHOR", T0002."CREATEDON", T0002."CHANGEDBY", T0002."CHANGEDON", T0002."PARDECLTYP", T0002."PARPASSTYP", T0002."TYPTYPE", T0002."TYPE", T0002."TABLEOF", T0002."PARVALUE", T0002."PAROPTIONL", T0002."PARPREFERD", T0002."LOCKED" FROM "SEOSUBCO" T0001, "SEOSUBCODF" T0002, "SEOSUBCOTX" T0003 WHERE T0001."CLSNAME" = T0002."CLSNAME" AND T0001."CMPNAME" = T0002."CMPNAME" AND T0001."SCONAME" = T0002."SCONAME" AND T0001."CLSNAME" = T0003."CLSNAME" AND T0001."CMPNAME" = T0003."CMPNAME" AND T0001."SCONAME" = T0003."SCONAME" AND T0001."SCOTYPE" = '0')

(IMP) ERROR: DbSlExecute: rc = 99

(IMP) ERROR: (SYB) (SQL error 30273)

(IMP) ERROR: Error message returned by DbSl:

(IMP) ERROR: (SYB) SQL error = 30273

(IMP) ERROR: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(TSK) INFO: 0.00 rows/sec, 0.00 MB/sec

(TSK) ERROR: Finished create for object "VSEOPARAM" of type "view" with error in 0 sec #20180314020300

(TSK) INFO: Starting create for object "VSEOPARENT" of type "view" #20180314020300

(IMP) WARNING: Ignoring failed drop: (SYB) DDL statement failed

(IMP) WARNING: (DROP VIEW "VSEOPARENT")

(IMP) WARNING: DbSlExecute: rc = 99

(IMP) WARNING: (SYB) (SQL error 30273)

(IMP) WARNING: Error message returned by DbSl:

(IMP) WARNING: (SYB) SQL error = 30273

(IMP) WARNING: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(IMP) ERROR: Task failed with error: (SYB) DDL statement failed

(IMP) ERROR: (CREATE VIEW "VSEOPARENT" ( "CLSNAME" , "REFCLSNAME" , "VERSION" , "STATE" ) AS SELECT T0001."CLSNAME", T0001."REFCLSNAME", T0001."VERSION", T0001."STATE" FROM "SEOMETAREL" T0001 WHERE T0001."RELTYPE" = '2')

(IMP) ERROR: DbSlExecute: rc = 99

(IMP) ERROR: (SYB) (SQL error 30273)

(IMP) ERROR: Error message returned by DbSl:

(IMP) ERROR: (SYB) SQL error = 30273

(IMP) ERROR: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(TSK) INFO: 0.00 rows/sec, 0.00 MB/sec

(TSK) ERROR: Finished create for object "VSEOPARENT" of type "view" with error in 0 sec #20180314020301

(TSK) INFO: Starting create for object "VSEOREFPRO" of type "view" #20180314020301

(IMP) WARNING: Ignoring failed drop: (SYB) DDL statement failed

(IMP) WARNING: (DROP VIEW "VSEOREFPRO")

(IMP) WARNING: DbSlExecute: rc = 99

(IMP) WARNING: (SYB) (SQL error 30273)

(IMP) WARNING: Error message returned by DbSl:

(IMP) WARNING: (SYB) SQL error = 30273

(IMP) WARNING: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(IMP) ERROR: Task failed with error: (SYB) DDL statement failed

(IMP) ERROR: (CREATE VIEW "VSEOREFPRO" ( "CLSNAME" , "REFCLSNAME" , "DONE" , "CPDNAME" , "SCONAME" , "REFCPDNAME" , "REFSCONAME" , "ACTION" , "AUTHOR" , "CREATEDON" , "CHANGEDBY" , "CHANGEDON" , "DESCRIP" , "REFAC_ID" , "CMPTYPE" , "TODO" ) AS SELECT T0002."CLSNAME", T0002."REFCLSNAME", T0002."DONE", T0001."CPDNAME", T0001."SCONAME", T0001."REFCPDNAME", T0001."REFSCONAME", T0001."ACTION", T0001."AUTHOR", T0001."CREATEDON", T0001."CHANGEDBY", T0001."CHANGEDON", T0001."DESCRIP", T0001."REFAC_ID", T0001."CMPTYPE", T0001."TODO" FROM "SEOREFPROT" T0001, "SEOREFTODO" T0002 WHERE T0002."REFCLSNAME" = T0001."CLSNAME" AND T0002."REFAC_ID" = T0001."REFAC_ID")

(IMP) ERROR: DbSlExecute: rc = 99

(IMP) ERROR: (SYB) (SQL error 30273)

(IMP) ERROR: Error message returned by DbSl:

(IMP) ERROR: (SYB) SQL error = 30273

(IMP) ERROR: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(TSK) INFO: 0.00 rows/sec, 0.00 MB/sec

(TSK) ERROR: Finished create for object "VSEOREFPRO" of type "view" with error in 0 sec #20180314020301

(TSK) INFO: Starting create for object "VSEORELAT" of type "view" #20180314020301

(IMP) WARNING: Ignoring failed drop: (SYB) DDL statement failed

(IMP) WARNING: (DROP VIEW "VSEORELAT")

(IMP) WARNING: DbSlExecute: rc = 99

(IMP) WARNING: (SYB) (SQL error 30273)

(IMP) WARNING: Error message returned by DbSl:

(IMP) WARNING: (SYB) SQL error = 30273

(IMP) WARNING: (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit.

(GEN) ERROR: Process was terminated (received signal SIGTERM or SIGINT)

(GEN) ERROR: Process was terminated (received signal SIGTERM or SIGINT)

(GEN) INFO: /tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/SYB/INSTALL/STD/ABAP/R3load: START OF LOG: 20180314025653

(GEN) INFO: ====================================================

(GEN) INFO: KERNEL: release 753, code page [UNICODE]

(GEN) INFO: Compile time "Feb 26 2018 19:41:19", sccsid "@(#) $Id: //bc/lmt_021_REL/src/upg/R3ld/R3load/R3ldmain.c#3 $ SAP"

(GEN) INFO: FORMAT: data 1.14, logging "classic", log level: 4

(GEN) INFO: ====================================================

(GEN) INFO: PROCENV: working directory "/tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/SYB/INSTALL/STD/ABAP", process id 14187

(GEN) INFO: CMDLINE: "/tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/SYB/INSTALL/STD/ABAP/R3load -i SAPVIEW.cmd -dbcodepage 4103 -l SAPVIEW.log -c 100000 -loadprocedure fast"

(GEN) INFO: ====================================================

(STA) INFO: Writing runtime statistics to "/tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/SYB/INSTALL/STD/ABAP/SAPVIEW.run" each 30 sec.

(GEN) INFO: ====================================================

(DMP) INFO: Resource usage: DATABASE times: 0.793/0.605/0.010 100.0%/100.0%/100.0% real/usr/sys

(DMP) INFO: Memory usage (buffer only): 20 MB

(GEN) ERROR: (DBS) db_connect failed with rc = 256

(GEN) ERROR: (DBS) DbSlErrorMsg rc = 99 'all DB errors, except for ...'

(GEN) ERROR: /tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/SYB/INSTALL/STD/ABAP/R3load: job finished with 1 error(s)

(GEN) INFO: /tmp/sapinst_instdir/SOLMAN72SR1/SOLMAN72SR1/SYB/INSTALL/STD/ABAP/R3load: END OF LOG: 20180314025654

Please let me know any other logs are required.

regards,

faheem

4f9wu.png (72.7 kB)
l4a1b.png (73.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers