I am getting below error while re-running the exisiting workflow which sources PWX SQL Server source to pwx target.
Message Code: PWXPC_10035
Message: [ERROR] Error message: [
[Informatica][SCLI PWX Driver] PWX-07038 Group Fetch read connection failed: rc=271 rc1=271 rc2=1266.
[Informatica][SCLI PWX Driver] PWX-00271 DBAPI Error. DB_READ failed for file <Capture Extract Realtime>.
[Informatica][SCLI PWX Driver] PWX-01266 DBNTC Receive READ header for file <Capture Extract Realtime> failed, rcs 260/2011/9980.
[Informatica][SCLI PWX Driver] PWX-02011 SQL fetch error. SQLCODE = 9980.
[Informatica][SCLI PWX Driver] PWX-04566 Capture Extract RC=9980 from CREAD_Read
[Informatica][SCLI PWX Driver] PWX-09980 CAPI i/f: RC=8 () from CAPI_Read.
[Informatica][SCLI PWX Driver] PWX-15756 Change data lost for requested sources.
Please let me know how to fix this. I have checked Listener service, replication service etc., and everything works fine.
This is the relevant part:
PWX-15756 Change data lost for requested sources.
What that means:
PC CDC session restart tokens point to data that no longer exists in SQL Server's Distribution DB.
Background: SQL Server Distribution DB Retention/Cleanup
SQL Server has a Retention Period for the Distribution DB.
When data is older than that, SQL Server's cleanup agent deletes it from the Distribution DB.
Background: PC CDC session restart/recovery
PC CDC sessions have restart tokens.
The session passes that to PWX to tell it where to start reading data.
Restart Tokens are updated when the session ends.
If you have Recovery Strategy set to "Resume from last checkpoint", then they are also updated at each commit boundary. (You should always set that for CDC)
What this means:
The data for the point in time where PC wants PWX to start reading is gone.
SQL Server has deleted it.
You'll have to cold start the PC CDC session to continue.
That may or may not result in lost data.