Post stopped with ORA-01036: illegal variable name/number. (4252230)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Post stopped with ORA-01036: illegal variable name/number.
Description

Post stops with the following error:
Event_log Error: "Unexpected Oracle error: ORA-01036: illegal variable name/number".
Cause

Root causes can include:

1. Bad record sent by Source.

2. The ORA-01036 error can be encountered when there is a difference between the Source table structure and that of the Target table.

Similarly, a difference between the table structure and the object cache files can result in the same error.

This can happen if a DDL to add a column is first performed on Target, then on Source, resulting in failed posting of DDL, as the column already exists:

ORA-01430: column being added already exists in table.

This results in the Target object cache missing the column, and the ORA-01036 error is encountered.
Resolution

1. Remove the transaction that is causing the ORA-01036 error by discarding or read-releasing the offending transactions.

2. The Target object cache file may be corrupt or miss DDL changes if Post has failed.

Use the copy cache utility

or

Rename the existing Target object cache file, copy the latest Source Capture object cache file to the Target, and rename it to the previous Target object cache file.

sp_ctrl> stop post
Copy the Capture object cache file from the Source to the Target in binary mode.

Rename the copied object cache file to the previous Target object cache file name.

sp_ctrl> start post

Note: The table may need to be repaired if data is lost due to discarding or read-releasing transactions.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Post stopped with ORA-01036: illegal variable name/number. (4252230)

Title

Description

Cause

Resolution

Leave a Comment