x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 137 subscribers
  • Views 4691 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
erandarg

Data Loading Into Database Error

Posted By

Dear Experts,

This is my first installation of Sage ERP X3. I followed installation document and installed everything accordingly. But in console application server Sage ERP X3 is not getting activated. Status is showing IDLE. It is running up to database admin creation successfully and gives me an error in data loading into database.

When i go to trace tab i can see below error.

6/6/2015 1:35:56 PM : ERROR - Error while checking valfil test on AABREV : ERR_VALFIL. (LibAdmAdonix.CheckValfilNT)
6/6/2015 1:35:56 PM : ERROR - Error while performing valfil test : ERR_VALFIL_TEST. (LibAdmAdonix.RunValFilMainNT)
6/6/2015 1:35:56 PM : ERROR - Please check file on server : C:\SAGE\SAGEX3V6\X3V6TST\Folders\X3\FILPLAT\_valfiltest.tra. (LibAdmAdonix.RunValFilMainNT)
6/6/2015 1:35:57 PM : FATAL - configuration aborted
6/6/2015 1:35:57 PM : FATAL - ERR_VALFIL_TEST

Can anybody help me to resolve this??

Eranda

  • 0

    Hello,

    Please post the contents of the _valfiltest.tra file. Ideally, it will show you a command that executes the valfil executable, then you can run that independently and get a better error. It could be something simple like the account you have designated for SQL Server within the console is not SA and there is a permissions problem.

    Another option is to open up SQL Profiler (assuming this is a SQL install and not Oracle) and run a trace to see if:

    1) A connection to the DB server is being made.

    2) What error from SQL's perspective is truly happening.

    Another option is to have a look inside SQL Server's error logs to see if anything was recorded in there at the time the valfil test occurred. Sometimes you get lucky here.

    Also, please have a look at this point when you get a chance:

    sagecity.na.sage.com/.../85053.aspx

    We like to get some basic background information when the questions on this forum come in as they help us give better answers such as things like the version you are trying to install (v6, v7, etc...).

    Hope this helps,

    Bob

*Community Hub is the new name for Sage City