October 15, 2013 at 1:20 am
Hi Everyone,
I am getting below error at time of SQL Server job running.
Executed as user: Administrator. Code: 0xC0029151 Source: Render Execute Process Task Description: In Executing "C:\Program Files (x86)\Report.exe" "" 10 "" at "", The process exit code was "-532459699" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:00:00 PM Finished: 10:04:02 PM Elapsed: 241.734 seconds. The package execution failed.
Note : Report.exe render reports from report server and merge into one report.
Please share your suggestions..
Regards,
Vaishu
October 15, 2013 at 2:13 am
It seems the Report.exe fails, or at least returns a return code that is not expected.
Does the package what it is supposed to do? Are the results achieved?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 15, 2013 at 2:59 am
Using Report.exe file render reports from report server and merge into one pdf file, One more thing is working fine in Dev server.
Note:Job is created long time it is production job.Ran successfully up to last month but now i am getting above error.
Regards,
Vaishu
October 15, 2013 at 3:19 am
venkat113 (10/15/2013)
Using Report.exe file render reports from report server and merge into one pdf file, One more thing is working fine in Dev server.Note:Job is created long time it is production job.Ran successfully up to last month but now i am getting above error.
Regards,
Vaishu
Well, the .exe is returning a code which is not normal.
Maybe you can output the results of the .exe to a flat file, by adding > log.txt at the end of the command?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 15, 2013 at 4:42 am
Well, the .exe is returning a code which is not normal.
Maybe you can output the results of the .exe to a flat file, by adding > log.txt at the end of the command?
How to add log.txt in command please provide steps.
Job is running fine suddenly it start failing any other reason to failed.
Regards,
Vaishu
October 15, 2013 at 5:10 am
What are the commandline arguments you specified in the Execute Process task?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 15, 2013 at 5:15 am
Arguments: "\" " + (DT_WSTR, 4) @[User::ID] + " \""
Path: C:\Program Files (x86)\Report.exe
Regards,
Vaishu
October 15, 2013 at 5:25 am
OK, now add > log.txt to the arguments.
"\" " + (DT_WSTR, 4) @[User::ID] + " \"" > log.txt
This will create a file called log.txt with the output of Report.exe in the folder C:\Program Files (x86)\.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 15, 2013 at 5:53 am
I am getting below error
TITLE: Expression Builder
------------------------------
Expression cannot be evaluated.
------------------------------
ADDITIONAL INFORMATION:
The expression contains unrecognized token "txt". If "txt" is a variable, it should be expressed as "@txt". The specifed token is not valid. If the token is intended to be a variable name, it should be prefixed with the @ symbol.
Attempt to parse the expression ""\" " + (DT_WSTR, 4) @[User::ID] + " \"" > log.txt" failed and returned error code 0xC00470A4. The expression cannot be parsed. It might contain invalid elements or it might not be well-formed. There may also be an out-of-memory error.
(Microsoft.DataTransformationServices.Controls)
------------------------------
BUTTONS:
OK
------------------------------
October 15, 2013 at 6:04 am
Ah, it's an expression. That should've been worth mentioning.
"\" " + (DT_WSTR, 4) @[User::ID] + " \" > log.txt"
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 15, 2013 at 9:01 am
Hi,
when i try to execute Report.exe file from command prompt i am getting below error.
Unhandled Exception: System.Net.WebException: The operation has timed out at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse
(WebRequestrequest) at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse (WebRequest request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at SSRSReport.ReportExecution2005.ReportExecutionService.Render(String Format String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warn
ing[]& Warnings, String[]& StreamIds)
Please share your suggestions on this.
Regards,
Vaishu
October 15, 2013 at 12:59 pm
Seems you are getting some sort of time out exception on the webservice?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2013 at 12:49 am
Hi,
Where we need to avoid Time out error in Console application or Report server?
Scenario: I am generating report.exe file from console application project in that i am calling reporting services2005 to render reports from report server.
How to improve Report server performance?
Please share your suggestions
Regards,
Vaishu
October 16, 2013 at 1:32 am
Did you write Report.exe yourself?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply