Problem:
The following error has occured
X120: Cannot find location name in SYSXDB.SYSLOCALS table.
An attempt was made to perform an operation on a location not found in the SYSXDB.SYSLOCALS table. Check the location path or location name specified in your command. When a location is created using the CREATE LOCATION command, an entry is inserted into the SYSXDB.SYSLOCALS table. If you are using a location that was not created with the CREATE LOCATION command, you may use the INSERT command to insert a record into the SYSXDB.SYSLOCALS table for the location.
Resolution:
This is because there is a mismatch between SYSTABLES and SYSLOCALS
Please do the following:
File>New>sql
In the SQL type the following:
SELECT *
FROM SYSTEM.SYSXDB.SYSLOCALS;
Scroll to the left and look for the column DBPATH. This is where the log files will be kept.
What you are going to want to do first is go to control panel > xdb server and shut down the xdb server. Then you are going to go to the directory of the unidata location and look for the log files. The log files will look similar to a983454.log and there is one that says anchor. Cut and paste these into another folder just as a backup. What you will also want to cut out of the folder is a file type DDB. Just cut and paste this into the backup folder created for the other logs. Now what you are going to want to do is go into control panel> Micro Focus XDB Server and click on configure button. Click on the logging tab and uncheck recovery. Then where it says log file size, increase to 1634. Then you will need to click OK and then start up the xdb server. Then try running the following:
UPDATE SYSTEM.SYSXDB.SYSLOCALS
SET LOCATION = (NAME OF LOCATION)'
WHERE LOCATION LIKE (NAME OF LOCATION)%';
Also run the following
UPDATE SYSTEM.SYSIBM.SYSLOCATIONS
SET LOCATION = '(NAME OF LOCATION)'
WHERE LOCATION LIKE '(NAME OF LOCATION)%';
#MFDS
#EnterpriseDeveloper
