Replication CDB problems

[Former Member]

hi all,

I face some troubles with my mobile client.

My ides database installation and my odbc connexion are OK.

I succed to replicate employes but when i want to replicate contact errors appears.

"Cannot insert the value NULL into column 'KOFRS_NUM', table 'ides.dbo.CDBC_REB_CN_CT'; column does not allow nulls. INSERT fails."

I checked the DB and the column 'KOFRS_NUM' doesn't accept NULL.

Is there anything to do or to replicate in order to initialise ides db to have right fields mapped ?

Best Regards.

[Former Member · Accepted solution]

Hi,

this is a known issue, at least for a colleague of me an myself for 2007 SP2.

There is currently an OSS message in work by SAP support.

As the client console table generation cannot change constraints you need to drop the table smokna1 manually, regenerate the table with clientconsole and run an extract for CAP and CON.

Please don't ask why the Solution Validation didn't find this issue...;-))

Regards,

Wolfhard

[former_member203347]

Hello,

Note 1254280 is available and should address this issue.

1) Extract the attachment from the note 1254280 to get Upgrade.SQL

2) Replace the Upgrade.SQL file in Bin.NET folder in the Mobile client

installation Directory (which is usually Program Files\SAP\Mobile\) with

the Upgrade.SQL from step 1.

3) Once the file is replaced, Perform Table script generation from

Client Console for all the Tables.

Important points to Consider:

a) Make sure you have the 'Include Helper Scripts' Checkbox Checked.

b) Make sure you have the Unicode Checkbox checked / unchecked if you

are generating the scripts for Unicode / Non-Unicode Client installation

accordingly.

c) Make sure you have 'not' checked the 'Generate Delta Scripts'

Checkbox, because we need to do a full table script generation here.

4) Once the scripts are generated successfully, Table structures will be

proper and you can go ahead with ConnTrans.

Regards,

Mohanrangan

[Former Member]

Hi Julien

This error (Cannot insert the value NULL into column 'KOFRS_NUM', table 'ides.dbo.CDBC_REB_CN_CT'; column does not allow nulls. INSERT fails) occurs when the table is properly generated with all the constraints. For that column 'KOFRS_NUM' Null constrains is not generated. That is the "default value" is missing. The condition is like if there is a NULL value for that column then replace it with the "default" value. But in your case the default value is missing i guess.

So please drp the table from the ides. Then go to client console and got o "Table script Generation" ,Connect to your CRM server and fully generate that table alone.

This should ensure that thhis table is created with all the constraints.

Thanks

Abishek

[Former Member]

Hi,

Oh it is working fine is it? did not notice tat :)...

Abishek

[Former Member]

another question

[Former Member]

hi,

thx for responding it work fine now.

I still have one problem.

When i m on the buisness partner detail screen although i have right to create bp i can't. the action is not active.

I feel that the system is processing and not responding because when i change the screen a software error appears.

Have you any idea ?

thx much

Best regards

Julien

[Former Member]

Hi,

I had a similar issue just this week after setting up a new system. BP detail is hanging even after importing all customizing.

What helped in my case was to import the IDES prefill data (which of course is mandatory!) and upload the data to CRM resp the other clients.

Regards,

Wolfhard

[Former Member]

Hi Julien,

If the new button on any tile (BP/Details is in this case) is inactive when there is a mismatch between the metadata generated and the tps.net file which UI framework accesses during run-time.

Try the following -

1.Generate all the tables corresponding to Bdoc CAPGEN_OBJECT_WRITE

2.Generate the Bdoc CAPGEN_OBJECT_WRITE

3.Now generate the Business Partner component from the Mobile Application studio.

Do it recursively.

4.Build the solution and then try to see if the new button is active.

Let me know if it works

Cheers

Vivek