Hi Barry. Thanks for that note number. Didn't help this time but I'll keep it for later!!
In the end I found SAP Note 961373 which described my problem, though the solution didn't work first time.
The note describes an SQL statement which can be applied to check if the note is valid - if it returns entries then the note is valid and the fix SQL statement provided should be applied. I did this, it altered a table entry (in CMS_TQUEUE). When running the check statement afterwards it returned no values, showing that the fix statement had done what it should have done. However, this did not remove the nullpointer error from the Assembly tab and did not get the CMS working.
I raised the problem with SAP, SAP's advice was to apply the note again. I ran the check statement again, it returned entries despite not doing so the previous evening. The entries altered by the fix SQL statement appear to have been restored to their previous values. I applied the fix statement again, which again altered one table entry. Once again, the check statement returned no values. This still did not fix the problem.
SAP's advice after this was to apply the note once more. Exactly the same as described above, no fix. However, overnight the table entries did not reappear. The check statement returns no values. The nullpointer error has disappeared from the Assembly tab and the CMS is once again working.
In summary, the note had to be applied three times over three successive days to be successful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.