Informatica Replication Jobs[ Salesforce to SQL Server] are failing [ Set up for Incremental Load], These Jobs were Working till 19-Sep-2012 6:30 AM EST time, All of a sudden the Jobs are failing even there is neither metadata changes in Salesforce nor in SQL Server.
Our Replication Job is a single task set to load all Object's for replication without Full Control to the SQL User. I tried doing metadata changes after i See this issue by Giving Alter previliges for first table then it truncated the first table and trying to truncate second object. Since SIT is going on I couldn't able to dare to do the database level changes to replicate everyhting freshly and I tried the below option. to check whether Workaround solution testing
1. Created a new mapping only for One Object[ User]
2. Given All Privileges to the SQL User.
3. Executed the Job.
4. Data Loaded successfully.
5 Revoked the Alter Privilege for SQL User.
6. Re-Executed the Job
7. No Change in Behavior . Still Job is failing.
I have given up and awaiting for the Support Guys to help me.
If anyone have this bad experience - appreciate if you guys can help, this is very critical and we are very near to Go-Live.
Thanks In Advance, for any help o suggestions.
I want to make sure that our Support team gets back to you. Have you submitted a support request from within the Informatica Cloud application? Posting here on the Community is not the same thing.