Data Synchronization Failure: ORA-06550 during sync.
Hi all!
I searched a long Time in Google but I didn't find any idea what is going wrong on my server.
We needed to extend a publication item. An additional field (Field A) of a Table (Table A) should be synchronized in the future.
So I did the following:
1. I added the field to the "Base Table" of the database
2. I extended the publication Item query via the Java API. (AlterPublicationItem)
3. I checked if the changes had been done (So in CEQ Table the new Coloumn has been added). All is OK.
We had implemented an own synchronization procedere. So we defined an DML Package that does some things before writing data to the basetables.
The package and the procedure is connected with the publication Item because MGP must know which procedures must be called for a dataset of a publication Item.
4. With PrintDML of a publication Item I can see the signature of a publication Item. I replaced the existing signature within specification and body with the signature that was printed out via printdml for the publication Item.
5. I did the changes within the package so the "new" Field should be written to database to during synchronization.
6. I compiled it and all is OK.
7. I reinstalled the client and tried to synchronize.
8. All seems OK but after opening the mobileServer Webpage I can see that my dataset has been written to the errorqeue.
The error is: boldORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'C$DML_VM_SCHAEDEN' ORA-06550: line 1, column 9: PL/SQL: Statement ignored bold
10: The next step was deleting and republishing the publicationitem. But I didn't chang anything. I restarted the server but the error appears when I try to synchronize a dataset of the publication Item that includes the new field.
Does anyone has any idea what i am doing wrong?
Many thanks for your help in advance!
Gr33ts
Martin