Skip navigation
Contact Us
1231 Views 1 Reply Latest reply: Sep 21, 2012 7:50 AM by Dan Smith RSS
Kannan Kandasamy Novice 26 posts since
Aug 2, 2012
Currently Being Moderated

Sep 21, 2012 1:39 AM

PWXPC_10035 Error

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.

 

Thanks,

Kannan

  • Dan Smith InfaEmp 185 posts since
    Jun 2, 2009
    Currently Being Moderated
    Sep 21, 2012 7:50 AM (in response to Kannan Kandasamy)
    PWXPC_10035 Error

    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.

More Like This

  • Retrieving data ...

Bookmarked By (0)