Thank you for your help
I download the Version 7.2 of Plex and the try to run the sample: . Net Support and Code Libraies. [salesSystem]
when i run SalesSystem with the Plex Runtime Console that working correctly.
But when i used the service(listerner2006) that is in error (with the same parameters than the plex runtime console)
- Problem with the date. Logs of the service:
Thank you for your reply
PS: More information about my conguration:
I used Plex.obrun.dll from 15/12/2014.
in my environment i used:
the empty date= 1753-01-01
;Settings for the default C# .NET server
Hi Fred -
When you get that famous PLEX0048 error it means that something went wrong with the DB access. The message is a bit misleading.
Access to the DB should give exactly the same results regardless of the use of the console or the server. I have seen this problem before and I think there is a difference in your DB configuration for the Runtime Console. Try to change the DB configuration for the server. Do not use the default settings for the connection string. I am using SQL server authentication and my connection string is usually blank except for the MARS option in some cases.
I can successfully run the sample application with the following settings :
MS SQL Error such as " [PLEX9999] Invalid object name 'SALESSURROGATESYSTEM_UPDV'. Client=127.0.0.1" usually happens when the login user does not have access to the default schema [dbo] .
thanks for your reply, i tried it to change the dataProvider from OLEDB to SQLCLIENT in the plex runtime console. and now the console doesn't work and in the log file i got this message:
07/08/15 16:27:25 Type=2 [PLEX0016] Starting CA Plex .NET Runtime Console on port 1998.
07/08/15 16:27:26 Type=2 [PLEX0042] CA Plex .NET Runtime Console started.
07/08/15 16:27:33 Type=4 [PLEX0001] Started client session. Client=127.0.0.1
07/08/15 16:27:34 Type=4 [PLEX0003] Received request to call function Order.HeaderBlockFetch_ObFnc. Client=127.0.0.1
07/08/15 16:27:35 Type=0 [PLEX0048] If SQLException mentioned about "overflow" for Date, Time or TimeStamp field, Configuration file's empty value for Date, Time and TimeStamp may be too small for you database. Client=127.0.0.1
07/08/15 16:27:35 Type=0 [PLEX9999] Nom d'objet 'ORDER_HEADER_FETCH' non valide. Client=127.0.0.1
But i stop my test about this sample. i will test now WFC services sample and web services.
thanks again for you reply lorenz.
What kind of login are you using ? Windows Account or SQL Server login ?
The error message 07/08/15 16:27:35 Type=0 [PLEX9999] Nom d'objet 'ORDER_HEADER_FETCH' non valide. Client=127.0.0.1 means, that the View ORDER_HEADER_FETCH is not found in the Database. This may have several reasons:
a) You are connecting to the wrong database
b) You are not authorized to the object
c) You are not allowed to access the default schema [dbo]
Let me know if you run into similar troubles when creating WCF Services :-) I still think this is just a SQL Sever issue and not a Plex runtime problem.
i used Windows acount but i tried with server login too and i got the same problem for the both even with WCF sample. But no problem, i stopped my test, i know now what we can do with plex about the web services.
Thank you for your help.
Hi Fred -
I am using Plex WCF as a service layer in some applications (the clients are hand written C#). WCF services access a SQL Server 2012 or 2008 instance without problems. I am confident that we will get it up and running once you have a need for WCF Services :-)
Frederic, were you able to sort through your issue?
I did not was able to solve this problem [with a SQL Server], But we used mainly a database DB2, i will try in the next day with a as400 connection.