Discussion:
sysexcel class doesn't run on batch
(too old to reply)
Stevanus HK
2009-06-29 07:35:01 UTC
Permalink
hello,

I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Markus
2009-06-29 10:30:01 UTC
Permalink
what version of AX do you use,
whats the error message ?
--
My LinkedIn Profile:
http://www.linkedin.com/in/noebauer
Xing:
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Stevanus HK
2009-06-30 03:29:01 UTC
Permalink
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
-----------------------------------------------------------------------------
Less Spam Better enjoyable experience
Visit : news://spacesst.com
Luegisdorf
2009-06-30 14:25:01 UTC
Permalink
Hi Stevanus

Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.

I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...

Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Stevanus HK
2009-07-01 01:56:01 UTC
Permalink
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Luegisdorf
2009-07-01 07:25:02 UTC
Permalink
Hi Stevanus

Can you post the exact error message?

Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Stevanus HK
2009-07-01 07:43:01 UTC
Permalink
The server-side impersonated (RunAs) session tried to invoke a method that is
available for client-side processing only. (S)Classes\ExcelBatch\run-line 4
(S)Classes\BatchRun\runJobStatic-line62
Post by Luegisdorf
Hi Stevanus
Can you post the exact error message?
Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Stevanus HK
2009-07-01 07:52:01 UTC
Permalink
Hi Patrick

i didn't run a job, i run a class that extend runbasebatch class

Regards
Stevanus HK
Post by Luegisdorf
Hi Stevanus
Jobs can be runned only on client tier. Move your x++ code from job to class
and it should run.
Regards
Patrick
Post by Stevanus HK
The server-side impersonated (RunAs) session tried to invoke a method that is
available for client-side processing only. (S)Classes\ExcelBatch\run-line 4
(S)Classes\BatchRun\runJobStatic-line62
Post by Luegisdorf
Hi Stevanus
Can you post the exact error message?
Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Luegisdorf
2009-07-01 10:49:01 UTC
Permalink
Sorry, I was irritated by 'runJobStatic', but what is the command line of

ExcelBatch.run line 4?

There seems to be the problem point.

Regards
Patrick
Post by Stevanus HK
Hi Patrick
i didn't run a job, i run a class that extend runbasebatch class
Regards
Stevanus HK
Post by Luegisdorf
Hi Stevanus
Jobs can be runned only on client tier. Move your x++ code from job to class
and it should run.
Regards
Patrick
Post by Stevanus HK
The server-side impersonated (RunAs) session tried to invoke a method that is
available for client-side processing only. (S)Classes\ExcelBatch\run-line 4
(S)Classes\BatchRun\runJobStatic-line62
Post by Luegisdorf
Hi Stevanus
Can you post the exact error message?
Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Stevanus HK
2009-07-02 04:08:01 UTC
Permalink
I forgot the exact code for the line 4 because i have been modified my code,
but it is beetwen 3 line code i write here

_sysexcelapplication = SysExcelApplication::construct();
_sysexcelworkbooks=_sysexcelapplication.workbooks();
_sysexcelworkbooks.add();
Post by Luegisdorf
Sorry, I was irritated by 'runJobStatic', but what is the command line of
ExcelBatch.run line 4?
There seems to be the problem point.
Regards
Patrick
Post by Stevanus HK
Hi Patrick
i didn't run a job, i run a class that extend runbasebatch class
Regards
Stevanus HK
Post by Luegisdorf
Hi Stevanus
Jobs can be runned only on client tier. Move your x++ code from job to class
and it should run.
Regards
Patrick
Post by Stevanus HK
The server-side impersonated (RunAs) session tried to invoke a method that is
available for client-side processing only. (S)Classes\ExcelBatch\run-line 4
(S)Classes\BatchRun\runJobStatic-line62
Post by Luegisdorf
Hi Stevanus
Can you post the exact error message?
Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Stevanus HK
2009-07-02 04:32:01 UTC
Permalink
i wonder that runImpersonated method has an effect in runBaseBatch class?

regards,
Stevanus
Post by Stevanus HK
I forgot the exact code for the line 4 because i have been modified my code,
but it is beetwen 3 line code i write here
_sysexcelapplication = SysExcelApplication::construct();
_sysexcelworkbooks=_sysexcelapplication.workbooks();
_sysexcelworkbooks.add();
Post by Luegisdorf
Sorry, I was irritated by 'runJobStatic', but what is the command line of
ExcelBatch.run line 4?
There seems to be the problem point.
Regards
Patrick
Post by Stevanus HK
Hi Patrick
i didn't run a job, i run a class that extend runbasebatch class
Regards
Stevanus HK
Post by Luegisdorf
Hi Stevanus
Jobs can be runned only on client tier. Move your x++ code from job to class
and it should run.
Regards
Patrick
Post by Stevanus HK
The server-side impersonated (RunAs) session tried to invoke a method that is
available for client-side processing only. (S)Classes\ExcelBatch\run-line 4
(S)Classes\BatchRun\runJobStatic-line62
Post by Luegisdorf
Hi Stevanus
Can you post the exact error message?
Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Luegisdorf
2009-07-02 07:27:01 UTC
Permalink
Hi Stevanus

I think, I found the problem point:
The base class SysExcel's property 'RunOn' is set to 'Client' (AX 2009).
That means, that this class can only used client side.

I see two options:
1. Change this property to 'called from' and compile forward, but on the
other hand this can raise some other problems
2. Build your own (or extended) SysExcel classes which can used for Server
and for Client and use these.

Sorry for that bad news, but it looks like work to get your Excel creation
running with batch.

About runImpersonated; I don't know about this method, but may be it
defines, if the batch must run in context of the user which has sheduled the
batch or if the batch can run with administrator rights??

Regards
Patrick
Post by Stevanus HK
I forgot the exact code for the line 4 because i have been modified my code,
but it is beetwen 3 line code i write here
_sysexcelapplication = SysExcelApplication::construct();
_sysexcelworkbooks=_sysexcelapplication.workbooks();
_sysexcelworkbooks.add();
Post by Luegisdorf
Sorry, I was irritated by 'runJobStatic', but what is the command line of
ExcelBatch.run line 4?
There seems to be the problem point.
Regards
Patrick
Post by Stevanus HK
Hi Patrick
i didn't run a job, i run a class that extend runbasebatch class
Regards
Stevanus HK
Post by Luegisdorf
Hi Stevanus
Jobs can be runned only on client tier. Move your x++ code from job to class
and it should run.
Regards
Patrick
Post by Stevanus HK
The server-side impersonated (RunAs) session tried to invoke a method that is
available for client-side processing only. (S)Classes\ExcelBatch\run-line 4
(S)Classes\BatchRun\runJobStatic-line62
Post by Luegisdorf
Hi Stevanus
Can you post the exact error message?
Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Stevanus HK
2009-07-02 08:04:11 UTC
Permalink
Hi Patrick

I have tried change property 'called from' to 'server' but it is also
doesn't work, i think extend sysexcel class not good idea, maybe i will
create a class to access excel with fileIO, thanks for your attention.

Kind Regards,
Stevanus
Post by Luegisdorf
Hi Stevanus
The base class SysExcel's property 'RunOn' is set to 'Client' (AX 2009).
That means, that this class can only used client side.
1. Change this property to 'called from' and compile forward, but on the
other hand this can raise some other problems
2. Build your own (or extended) SysExcel classes which can used for Server
and for Client and use these.
Sorry for that bad news, but it looks like work to get your Excel creation
running with batch.
About runImpersonated; I don't know about this method, but may be it
defines, if the batch must run in context of the user which has sheduled the
batch or if the batch can run with administrator rights??
Regards
Patrick
Post by Stevanus HK
I forgot the exact code for the line 4 because i have been modified my code,
but it is beetwen 3 line code i write here
_sysexcelapplication = SysExcelApplication::construct();
_sysexcelworkbooks=_sysexcelapplication.workbooks();
_sysexcelworkbooks.add();
Post by Luegisdorf
Sorry, I was irritated by 'runJobStatic', but what is the command line of
ExcelBatch.run line 4?
There seems to be the problem point.
Regards
Patrick
Post by Stevanus HK
Hi Patrick
i didn't run a job, i run a class that extend runbasebatch class
Regards
Stevanus HK
Post by Luegisdorf
Hi Stevanus
Jobs can be runned only on client tier. Move your x++ code from job to class
and it should run.
Regards
Patrick
Post by Stevanus HK
The server-side impersonated (RunAs) session tried to invoke a method that is
available for client-side processing only. (S)Classes\ExcelBatch\run-line 4
(S)Classes\BatchRun\runJobStatic-line62
Post by Luegisdorf
Hi Stevanus
Can you post the exact error message?
Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Stevanus HK
2009-07-02 08:07:01 UTC
Permalink
Post by Luegisdorf
Hi Stevanus
The base class SysExcel's property 'RunOn' is set to 'Client' (AX 2009).
That means, that this class can only used client side.
1. Change this property to 'called from' and compile forward, but on the
other hand this can raise some other problems
2. Build your own (or extended) SysExcel classes which can used for Server
and for Client and use these.
Sorry for that bad news, but it looks like work to get your Excel creation
running with batch.
About runImpersonated; I don't know about this method, but may be it
defines, if the batch must run in context of the user which has sheduled the
batch or if the batch can run with administrator rights??
Regards
Patrick
Post by Stevanus HK
I forgot the exact code for the line 4 because i have been modified my code,
but it is beetwen 3 line code i write here
_sysexcelapplication = SysExcelApplication::construct();
_sysexcelworkbooks=_sysexcelapplication.workbooks();
_sysexcelworkbooks.add();
Post by Luegisdorf
Sorry, I was irritated by 'runJobStatic', but what is the command line of
ExcelBatch.run line 4?
There seems to be the problem point.
Regards
Patrick
Post by Stevanus HK
Hi Patrick
i didn't run a job, i run a class that extend runbasebatch class
Regards
Stevanus HK
Post by Luegisdorf
Hi Stevanus
Jobs can be runned only on client tier. Move your x++ code from job to class
and it should run.
Regards
Patrick
Post by Stevanus HK
The server-side impersonated (RunAs) session tried to invoke a method that is
available for client-side processing only. (S)Classes\ExcelBatch\run-line 4
(S)Classes\BatchRun\runJobStatic-line62
Post by Luegisdorf
Hi Stevanus
Can you post the exact error message?
Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
b***@gmail.com
2014-07-17 14:21:13 UTC
Permalink
Hi stevanus,

Did you got the solution for this .Even i too faceing the same problem.

My Scnario is i want to run the Excel report through batch job.

Can you give me solution to run the this report.

Luegisdorf
2009-07-01 07:47:01 UTC
Permalink
Hi Stevanus

Do you try to run a job from inside a class? If yes, that's the problem:
Jobs can be runned only on client tier. Move your x++ code from job to class
and it should run.

Regards
Patrick
Post by Stevanus HK
The server-side impersonated (RunAs) session tried to invoke a method that is
available for client-side processing only. (S)Classes\ExcelBatch\run-line 4
(S)Classes\BatchRun\runJobStatic-line62
Post by Luegisdorf
Hi Stevanus
Can you post the exact error message?
Regards
Patrick
Post by Stevanus HK
I did change the run on property to server and off course ms excell installed
on the server and the file placed on the server. but still doesn't work for
me.
Post by Luegisdorf
Hi Stevanus
Batch in AX 2009 runs on server, there's no client connection, therefore
client-side classes cannot be run.
I suggest to change the runOn property on that class to get it run. But you
have to place the file on server's file system .. and MS Excel needs to be
installed on server too ...
Regards
Patrick
Post by Stevanus HK
i use ax 2009, error message said that client side code can't run on server
side something, forgot the exact message.
Post by Markus
what version of AX do you use,
whats the error message ?
--
http://www.linkedin.com/in/noebauer
https://www.xing.com/profile/Markus_Noebauer
Post by Stevanus HK
hello,
I made an application to export and import excel Data with sysExcel, i want
to run this application on batch server, but sysexcel just run on client
side, i want to know how to create application to export and import excel
data that can run on batch server
Loading...