I am executing a workflow in informatica which is supposed to inset values in a target file.
Some of the records are getting inserted but i get an error after a few insertions saying:
[Informatica][ODBC PWX Driver] PWX-00267 DBAPI error for file……… Write error on record 119775 Requested 370 SQLSTATE [08S01]
Is this because of file constraints of how the record can be or due to some other reasons?
I'm not sure if this is exactly the case, but looking for the error code 08S01 I've found this site that lists Data Provider Error Codes. Under SQLCODE 370 (assuming this is what your error message indicates) I've found:
Message: There are insufficient resources on the target system to complete the command. Contact your server administrator.
Reason: The resource limits reached reply message indicates that the server could not be completed due to insufficient server resources (e.g. memory, lock, buffer).
Action: Verify the connection and command parameters, and then re-attempt the connection and command request. Review a client network trace to determine if the server returned a SQL communications area reply data (SQLCARD) with an optional reason code or other optional diagnostic information.
