cancel
Showing results for 
Search instead for 
Did you mean: 

SQL 2005 SAP R/3 4.6C - DBSL error RC=99 on import of Basis 4.6C SP 39

Former Member
0 Kudos

Hi,

I have just built a R/3 4.6C system on SQL 2005 with 4.6D_EXT kernel. The build was done using R3load to export from the 4.6C/SQL 2000/32bit system and import to 4.6C/SQL 2005/64bit system. The source 4.6C system only had Basis support package 37 applied, and I am trying to apply Basis 4.6C 38-57 on the 4.6C/SQL 2005/64bit system (in preparation for an ECC6 upgrade) and I get the following error:

EXEC SQL: SELECT ID,OBJECT,LANGU,TYP,VERSION FROM DOKIL WHERE (LANGU IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,

[developertra,00000] ExecuteAndFlush return code: 0x80040e10 Stmt: [CREATE PROCEDURE ##Y8IBASAPDEIBD00000025600000000006164133 @P

99972 0.099972

[developertra,00000] MapHr:80040E10 DB_E_PARAMNOTOPTIONAL 43 0.100015

[developertra,00000] HandleOledbError [ExecuteAndFlush,line 33423]: Error/Message: (err 0, sev 0), No value given for one or more

96 0.100111

[developertra,00000] DbSlPrepare - Error 99 (dbcode -2147217904) on proc. creation

56 0.100167

[developertra,00000] DbSlPrepare - <CREATE PROCEDURE ##Y8IBASAPDEIBD00000025600000000006164133 @P000 varchar(3072) = ' ', @P001 v

105 0.100272

[developertra,00000] 1 times error (0,0) in sequence 30 0.100302

[developertra,00000] dbdsmss: DBSL99 SQL0 27 0.100329

[developertra,00000] No value given for one or more required parameters.

62 0.100391

[dbds ,00589] ***LOG BY2=>sql error 0 performing FET

66 0.100457

[dbds ,00589] ***LOG BY0=>No value given for one or more required parameters.

I have checked the collation setting in SQL 2005 and it is:

select serverproperty('collation')

SQL_Latin1_General_CP850_BIN2

There are 97000 odd entries in DOKIL, so I don't think that is the problem.

Would appreciate any assistance.

Kind regards,

Sheryl.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi ,

Instead of doing the build with export import, you can try to do the same with backup restore,,

But remember your sql2000 should be on bin2... then you can take backup and restore.

Since it is from 2000 to 2005 the restore would happen and it will work fine.

Try this and check out, since the error you have pasted is not clearly giving any picture...

Regards,

Ravi.