MSA50-SP11-Importing customizing bdocs not possible

[gerd_hotz]

Hello experts,

I have installed msa-field-client on my notebook, but there I have the

problem that I cannot import customizing-bdocs into database, other bdocs

could be imported. SO I did generation of metadata/tablescripts but this

didn't help.

Does anybody know what I can do again ??

Thanks Gerd

[former_member204283 · Accepted solution]

Hello Gerd

Do you have all the tables in place for the customizing bdoc at the Mobile client ?

Below Notes should be of help:

Note 1232529

Note 1254280

Note 1071267

If not, TL_TRACE.dat from %temp% directory will be of help to me

Thank you

Best Regards

Jothi

[Former Member]

Hi,

I remember that you had this issue already some months before?!

How was it solved then?

Regards,

Wolfhard

[gerd_hotz]

Hi,

when I install note 1071267 I cannot import customizing bdocs,

but the error described in this note is solved.

IN order to import customizing-bdocs I have to install an older mwimport.dll

but then I have the problem with longtexts described in above note.

It seems that I have to open an oss-message.

Maybe someone has another solution ?

Thanks Gerd

[former_member204283]

Hello Gerd

Info from the TL_TRACE.DAT file(in the %temp% directory) for the last ConnTrans, where you had import failure, for the Customizing will be a lot of help here.

Thank you

Best Regards

Jothi

[gerd_hotz]

Hello, here the trace:

20.10.2008 09:05:29 : Start of Log

Initialize on ExInterface success

Created Statistical log object

Opening new DB Connections...

Successfully opened connection to the Ides database

No where clause for the table SMOT001W

20.10.2008 09:05:29 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.DBHandler.ExecNonQuery(String& query)

bei MWImport.DBHandler.ExecuteSql(String sql)

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

20.10.2008 09:05:29 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. QBlocker : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. MsgOrder = 2

No where clause for the table SMOT005F

20.10.2008 09:05:29 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.DBHandler.ExecNonQuery(String& query)

bei MWImport.DBHandler.ExecuteSql(String sql)

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

20.10.2008 09:05:29 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. QBlocker : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. MsgOrder = 3

No where clause for the table SMOT171T

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.DBHandler.ExecNonQuery(String& query)

bei MWImport.DBHandler.ExecuteSql(String sql)

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. QBlocker : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. MsgOrder = 4

Bulk : Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

No where clause for the table SMOTNLST

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.DBHandler.ExecNonQuery(String& query)

bei MWImport.DBHandler.ExecuteSql(String sql)

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. QBlocker : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

1. MsgOrder = 6

No where clause for the table SMOTVAVT

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.DBHandler.ExecNonQuery(String& query)

bei MWImport.DBHandler.ExecuteSql(String sql)

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. QBlocker : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

1. MsgOrder = 7

No where clause for the table SMOTKUKT

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.DBHandler.ExecNonQuery(String& query)

bei MWImport.DBHandler.ExecuteSql(String sql)

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. QBlocker : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

Violation of PRIMARY KEY constraint 'PK__SMOT171T__6F52A451'. Cannot insert duplicate key in object 'SMOT171T'.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

1. MsgOrder = 8

Bulk : Violation of PRIMARY KEY constraint 'PK__SMOTNLST__7E5FDDB7'. Cannot insert duplicate key in object 'SMOTNLST'.

Violation of PRIMARY KEY constraint 'PK__SMOTNLST__7E5FDDB7'. Cannot insert duplicate key in object 'SMOTNLST'.

Violation of PRIMARY KEY constraint 'PK__SMOTNLST__7E5FDDB7'. Cannot insert duplicate key in object 'SMOTNLST'.

Violation of PRIMARY KEY constraint 'PK__SMOTNLST__7E5FDDB7'. Cannot insert duplicate key in object 'SMOTNLST'.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

Bulk : Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

No where clause for the table SMOTVKWZ

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.DBHandler.ExecNonQuery(String& query)

bei MWImport.DBHandler.ExecuteSql(String sql)

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. QBlocker : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

1. MsgOrder = 11

No where clause for the table SMOTVSDT

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.DBHandler.ExecNonQuery(String& query)

bei MWImport.DBHandler.ExecuteSql(String sql)

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. QBlocker : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

1. MsgOrder = 12

No where clause for the table SMOTVBRT

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.DBHandler.ExecNonQuery(String& query)

bei MWImport.DBHandler.ExecuteSql(String sql)

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

20.10.2008 09:05:30 : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

1. QBlocker : Line 1: Incorrect syntax near 'COLLATE'.

Line 1: Incorrect syntax near 'DATABASE_DEFAULT'.

bei MWImport.QInDataImport.ProcessZapMessage(XmlTextReader& oMsgRdr)

bei MWImport.QInDataImport.ReceiveCurrentMessage(String& QBlockerName)

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

Violation of PRIMARY KEY constraint 'PK__SMOTKUKT__75CA97B6'. Cannot insert duplicate key in object 'SMOTKUKT'.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

The statement has been terminated.

1. MsgOrder = 13

Message Count - Service = 0

Message Count - Error = 0

Message Count - Zap = 9

Message Count - QBlocker = 0

Message Count - Bulk = 3

Message Count - UnKnown = 0

Message Count - Confirmation = 0

Message Count - Archive = 0

Message Count - CurrentState = 0

Message Count - QBCurrentState = 0

Message Count - Import = 1

Start Time : 20.10.2008 09:05:29

InitializeTime : 843

MetaDataAccess : 46

ReadQInData : 15

Confirm QIn Msgs : 31

ApplicationDBTime : 437

ProcessZapTime : 0

Other Times : 203

Time for 4.0 xml : 0

End Time : 20.10.2008 09:05:30

Total Time : 1578

Message Size : 7177 bytes

InitializeTime % : 53.4178217821782

MetaDataAccess % : 2.91485148514851

ReadQInData % : 0.95049504950495

Confirm QIn Msgs % : 1.96435643564356

ApplicationDBTime % : 27.6910891089109

Other Times % : 12.8633663366337

Number of Database Connection Opened = 1

Number of Database Connection Closed = 0

20.10.2008 09:05:30 : End of Log

[gerd_hotz]

Hello again,

problem is solved.

I've executed note 1232529 EXEC sp_dbcmptlevel ides, 80

in query analyzer and now importing in conntrans works proper.

Thanks and best regards

Gerd