x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 6 replies
  • Subscribers 118 subscribers
  • Views 2998 views
  • Users 0 members are here
Browse Forums
Announcements
270
topics
260
replies
Databases and Operating Systems
760
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
852
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
876
topics
3k
replies
Sage CRM for Sage 300
183
topics
412
replies
Tascoli

Error in File OELABEL ... The table could not be found

SOLVED
Posted By

Hi Citiers,

I have searched around and and followed all the tips found here there there with no uck.

I decided to knock on your door to check if you have any solution, hint, tips and a clue on how to debug this error. 

We got an Windows Server 2019 Datacenter on Azure and installed:

   SAGE 300 version 2019 PU6.

   SAGE .NET Libraries 2019 PU2

   SAP Crystal Reports RT for .NET Framework (32-bit)- 13.0.28.3597

   SAP Crystal Reports RT for .NET Framework (64-bit)  - 13.0.28.3597

I assume that SAGE 300 is compatible with Azure environment andWindows Server 2019 Datacenter !!!!

I get errors running the installed reports if it is based on DLL. For instance:

Running O/E Forms Shipping Labels (OELABEL.RPT) I get the following error:

    Error in File OELABEL
    11204_2544_(B3354476- ....).rpt:
    The table could not be found

I got similar errors for other reports like O/E Forms Invoices, etc.  i found not errors logged to Windows event logs. 

Please let me know how to fix this problem ??? 

Many thanks

Parents
  • 0

    Make sure the OERPT.INI DATAPIPE settings are correct for that particular report.

  • +1 in reply to Jay Converse Acumen
    verified answer

    Hi Jay,

    I am glad you are not on vacation ! Slight smile

    i believe the values are the standard by install.

    '************** Object id = OE1500 ********************
    [OELABEL]
    type=DATAPIPE
    heading=28060
    crystal=OELABEL
    orientation=portrait
    paper size=1
    optparams=6
    2=FUNCDEC STRING 28066
    3=SORTBY STRING 28067
    4=SORTFROM STRING 28068
    5=SORTTO STRING 28069
    6=PRINTED STRING 28070
    7=REQUIRED STRING 28071
    datapipe path=..\
    datapipe query="oelbl.dll=OELABEL\n%SORTBY%\n%SORTFROM%\n%SORTTO%\n%PRINTED%\n%REQUIRED%\n"

    By the way, I forgot to say that I run SAGE 2012 on an old Windows Server 2012! with the same report/oerpt.ini and all works fine. 

Reply
  • +1 in reply to Jay Converse Acumen
    verified answer

    Hi Jay,

    I am glad you are not on vacation ! Slight smile

    i believe the values are the standard by install.

    '************** Object id = OE1500 ********************
    [OELABEL]
    type=DATAPIPE
    heading=28060
    crystal=OELABEL
    orientation=portrait
    paper size=1
    optparams=6
    2=FUNCDEC STRING 28066
    3=SORTBY STRING 28067
    4=SORTFROM STRING 28068
    5=SORTTO STRING 28069
    6=PRINTED STRING 28070
    7=REQUIRED STRING 28071
    datapipe path=..\
    datapipe query="oelbl.dll=OELABEL\n%SORTBY%\n%SORTFROM%\n%SORTTO%\n%PRINTED%\n%REQUIRED%\n"

    By the way, I forgot to say that I run SAGE 2012 on an old Windows Server 2012! with the same report/oerpt.ini and all works fine. 

Children

*Community Hub is the new name for Sage City