Page 1 of 1

Unable to allocate communication resources?

Posted: Wed Apr 17, 2013 12:08 am
by pkll
Hi All,

Code: Select all

Fatal Error: Unable to allocate communication resources
I am getting above Error.

Let me know why this error is comming?

Posted: Wed Apr 17, 2013 1:33 am
by ray.wurlod
Because it was not able to allocate communication resources.

That is all of the information available in the error message.

You must help us to help you. What were you trying to do at the time? What does your design look like? What stage type threw this error? And so on. Without that information we have even less information than you do, and can only respond as I did in my first paragraph.

Posted: Wed Apr 17, 2013 4:18 am
by pkll
Hi Ray,

I am unable to read your entire sentence....

Re: Unable to allocate communication resources?

Posted: Wed Apr 17, 2013 7:09 am
by stuartjvnorton
Ray was asking what you were trying to do when you got this error.
IIS is a big place: help us help you. ;-)

Posted: Wed Apr 17, 2013 8:59 am
by priyadarshikunal
along with that, are you getting any other warning or error messages?

Posted: Fri Apr 19, 2013 12:33 am
by pkll
Yes I am getting below warnings and errors..

Code: Select all

Oracle_Connector_21,0: The OCI function OCIStmtExecute returned status 1. Error code: 1, Error message: ORA-00001: unique constraint (SCOTT.SYS_C005447) violated.
Oracle_Connector_21,0: The OCI function OCIStmtExecute returned status -1. Error code: 24,381, Error message: ORA-24381: error(s) in array DML. (CC_OraStatement::executeInsert, file CC_OraStatement.cpp, line 1,538)
Oracle_Connector_21,0: The runLocally() of the operator failed.
Oracle_Connector_21,0: Operator terminated abnormally: runLocally() did not return APT_StatusOk
node_node1: Player 3 terminated unexpectedly.
HIST_DETAILS,0: Failure during execution of operator logic.
HIST_DETAILS,0: Output 0 produced 37031 records.
HIST_DETAILS,0: Fatal Error: Unable to allocate communication resources

I had run this job one month before it had executed .but it is not executed right now it is showing above errors.

Posted: Fri Apr 19, 2013 1:08 am
by ray.wurlod
Always start with the first error - "unique constraint (SCOTT.SYS_C005447) violated". There's nothing wrong with the DataStage job design. You're trying to insert a record that violates the indicated UNIQUE constraint. Answer: don't. Perhaps add some checking to your job.

Posted: Fri Apr 19, 2013 1:28 am
by pkll
Hi Ray,

Thanks for ur reply I am unable to read ur entire sentence.
Could you plz explain ?

Posted: Fri Apr 19, 2013 5:00 am
by ray.wurlod
Ur was a city in ancient Babylonia. The second person personal pronoun in English is spelled "your". Plz may be a town in eastern Europe. The word you needed is spelled "Please".

We strive for a professional standard of written English here at DSXchange, not least to assist those of us whose first language is not English.

The reason you were not able to read my entire sentence is that you have not yet purchased yourself a premium membership. (I am assuming here that this is what you wanted explained.) Premium membership is the mechanism by which the hosting and bandwidth costs of DSXchange are met.