Plex 2E

Expand all | Collapse all

Sample [.net Support and code libraries] [PLEX0048] error

Jump to Best Answer
  • 1.  Sample [.net Support and code libraries] [PLEX0048] error

    Posted 08-07-2015 05:24 AM

    Hi,

     

    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:

    07/08/2015 11:00:23 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/2015 11:00:23 Type=0 [PLEX9999] Nom d'objet 'ORDER_HEADER_FETCH' non valide. Client=127.0.0.1

     

    Thank you for your reply

     

    Fred M.

     

    PS: More information about my conguration:

    I used Plex.obrun.dll from 15/12/2014.

     

    in my environment i used:

    Culture= fr-FR

    the empty date= 1753-01-01

     

    file .ini:

    [RemoteCSharp]

    ;Settings for the default C# .NET server

    System=localhost

    OpSys=WINCLR

    Protocol=WINTCPIP

    Port=2006

    Environment=SalesSystem

    Timeout=60

    Client Encoding=Windows-1252

    Program=

    Path=

    Buffer Size=1

    Package=



  • 2.  Re: Sample [.net Support and code libraries] [PLEX0048] error

    Posted 08-07-2015 07:04 AM

    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 :

     

    SQLCLIENT config.jpg

    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] .



  • 3.  Re: Sample [.net Support and code libraries] [PLEX0048] error

    Posted 08-07-2015 10:36 AM

    Hi Lorenz,

     

    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.



  • 4.  Re: Sample [.net Support and code libraries] [PLEX0048] error

    Posted 08-07-2015 10:50 AM

    Fred -

     

    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.

     

    Best

    Lorenz



  • 5.  Re: Sample [.net Support and code libraries] [PLEX0048] error

    Posted 08-10-2015 09:23 AM

    hi Lorenz,

     

    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.

     

    best regard

    Fred



  • 6.  Re: Sample [.net Support and code libraries] [PLEX0048] error

    Posted 08-10-2015 09:37 AM

    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 :-)

     

    Best regards

    Lorenz



  • 7.  Re: Sample [.net Support and code libraries] [PLEX0048] error

    Posted 08-31-2015 01:55 PM

    Frederic, were you able to sort through your issue?



  • 8.  Re: Sample [.net Support and code libraries] [PLEX0048] error
    Best Answer

    Posted 09-02-2015 07:49 AM

    Hi Lenn

     

    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.

     

    Best regards.