x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 137 subscribers
  • Views 821 views
  • Users 0 members are here
Browse Forums
Announcements
235
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
411
replies
Sage Intelligence Reporting
121
topics
322
replies
chunheng

X3 engine error: DBIDENT3 : decla_mbr(OBJECT):File does not exist in the archive!(2) <empty stack>

SOLVED
Posted By

Hi,

Found a situation here:

When I observed the Console import, it can import fine.

It clears 1.1k tables import like a champ with 100% clear

When it comes to Console validation, the tables are hit with warnings.

```

<0001 Erreur en validation de la vue
<0001 Error No 76
<0001
<0001 C:\Sage\X3ERPV11\Folders\LIVE3\adxodbc : SQL Server Error

```

Additional note: The sa password has a hyphen (-), I do not think this should be a cause of concern? I can type the password out in console with no issue.

From ODBC side, I noticed a lack of ODBC 32-bit entry in System DNS for ADX_{SolutionName} which should be added by Sage X3 component. I am unsure how to add that back.

The setup is single-tier; everything in single server.

  • +1
    verified answer

    Hi chunheng,

    There is a file missing, maybe because you have copied/zipped the exported folder during business time?
    You should have seen a message like this here during zipping

    Navigate to Function ARCHGENTRT and select your fresh imported folder.
    After generating the archive you will be able to access the endpoint without errors.

    The message with the views is caused by one or more entries in the view with a name of the folder (e.g. LIVE) in a querie.
    That couldn't be found because the new name of th fodler is e.g. LIVE3. Correct the Queries and validate the view.

    Regards

  • 0 in reply to Markus Huber

    Approved as answer.

    Confirmed from my side folder access works after running in X3 endpoint, Archive Generation (ARCHGENTRT) function using LIVE3 folder.

    atx.ind was indeed copied in business time.

    Views part I am getting my development team attention to check first before I run full dictionary validation.

    Thank you for prompt answer.

*Community Hub is the new name for Sage City