You are currently reviewing an older revision of this page.
Document Type: TechNote Product(s): SELECTserver Version(s): 08.09.00.00 - Present Original Author: Jonathan Jezorski, Bentley Technical Support Group
Document Type: TechNote
Product(s): SELECTserver
Version(s): 08.09.00.00 - Present
Original Author: Jonathan Jezorski, Bentley Technical Support Group
Upon opening the SELECTserver Administration page, a message displays informing that the SELECTserver usage logs have not been transmitted. As a result the SELECTserver is left in a disabled state, and the only options along the left hand side links are "Request/Update License File" and "Transmit Usage Logs".
In order to resolve the error message, choose "Transmit Usage Logs" and follow the 4 steps.
When choosing step 1 you may receive the following error message: 0 LOGS FOUND TO PROCESS
When choosing step 1 you may receive the following error message:
0 LOGS FOUND TO PROCESS
If this message appears, it is most likely a result of the SELECTserver Serial Number and Server Activation Key being entered incorrectly or if the SELECTserver service has not been started. The other possibility could have to do with Proxy Server Settings not being correct (Proxy Servers are not required by Bentley, however if the network where SELECTserver is installed requires Proxy Settings, then this information will need to be entered).
The following are solutions to resolve the 0 logs to be processed error:
Please ensure that the SELECTServer service is running.
Open the Administrative Site page.
NOTE: Check the SELECTserver version (bottom left-hand corner of the page). If your version is prior to the 08.11.07.35 version, this process will not be effective. Please go to "SOLUTION 2".
Look down the left hand side of the page under the ADMINISTRATION section there is a link "Manage Services". Select the link
Please note that your SELECTserver service and Bentley SELECTserver Gateway services are running (green) and that there are a few SELECTserver Tasks. We are concerned with the Usage Log Processing, Usage Log Posting, and Data Update Service tasks.
Using the associated "RUN NOW" soft button to the right of each service task run the Usage Log Processing task.
NOTE: The STATE of the task will change from "IDLE" to "RUNNING". Allow the task to complete its processing. The page display is dynamic so you will be able to see the status change back to IDLE when it is done.
You will need to complete this action for all three task in this order.
Usage Log Processing Usage Log Posting Data Update Service
Upon completion the "Last Run Results" should read "Success" and all of the links down the left-hand side of the Administration Site page should be active.
NOTE: If you were configured for Manual Usage Transmission all of your links will not be active but you will now have "LOGS" to process and can use your normal procedure to complete that task. At the completion of that process all of your links will be active.
SELECTserver can be corrected through either a Command Prompt or by using the SQL Express Studio Management Console.If using SQL Express Studio Management the following will fix the problem.
1. Open the Console and Locate the Database which SELECTserver is using.2. One the Database if located, right click it and choose "NEW QUERY"3. Once here you can disable the manual logs transmittal by typing the following: update ss_Configuration set KeyValue='False' where KeyName='SS_EnableManualLogTransmitting' Then highlight the line and choose "F5" make sure this is FALSE (NOTE: If not urgent this will fix the message within SELECTserver the next time it tries posting the usage logs (usually 12:00 AM) If this is urgent, this step can be expedited by adjusting the Log Processing Time by entering the next line. INSERT INTO ss_Configuration (KeyName, KeyValue) VALUES ('SS_RunTime_UsageLogProcessingService', '11:00:00') 4. Change the time to 1 minute past the current time (ie if it is 2:00 set the time to ‘02:01:00') 5. Once this adjustment has been made enter the next line for the posting: INSERT INTO ss_Configuration (KeyName, KeyValue) VALUES ('SS_RunTime_UsageLogPostingService', '11:00:00') 6. Change the time to 5 minute past the current time (i.e. if it is 2:00 set the time to ‘02:05:00') 7. Once this is done you must restart the Bentley SELECTserver Service within your Windows Services page (Start > Control Panel > Administrative Tools > Services) 8. After the service has been restarted, you must reset IIS. You can do this by choosing (Start > Run > enter IISRESET > then hit OK.
update ss_Configuration set KeyValue='False' where KeyName='SS_EnableManualLogTransmitting'
Then highlight the line and choose "F5" make sure this is FALSE
(NOTE: If not urgent this will fix the message within SELECTserver the next time it tries posting the usage logs (usually 12:00 AM)
If this is urgent, this step can be expedited by adjusting the Log Processing Time by entering the next line.
INSERT INTO ss_Configuration (KeyName, KeyValue) VALUES ('SS_RunTime_UsageLogProcessingService', '11:00:00')
4. Change the time to 1 minute past the current time (ie if it is 2:00 set the time to ‘02:01:00')
5. Once this adjustment has been made enter the next line for the posting:
INSERT INTO ss_Configuration (KeyName, KeyValue) VALUES ('SS_RunTime_UsageLogPostingService', '11:00:00')
6. Change the time to 5 minute past the current time (i.e. if it is 2:00 set the time to ‘02:05:00')
7. Once this is done you must restart the Bentley SELECTserver Service within your Windows Services page (Start > Control Panel > Administrative Tools > Services)
8. After the service has been restarted, you must reset IIS. You can do this by choosing (Start > Run > enter IISRESET > then hit OK.
If using a CMD prompt, enter the following CMD:
osql -S MyServerName\InstanceName -U user -P password -Q "BACKUP DATABASE [Database Name] TO DISK = N'c:\SSXM_DB_BACKUP.bak' WITH NOFORMAT, INIT, NAME = N'[Full Backup]', SKIP, NOREWIND, NOUNLOAD, STATS = 10"
The InstanceName can be found in the server definition section of the SELECTserver Database Setup tool.
Once at this location within the CMD Prompt, Enter the same commands that would be entered using SQL Express Studio Management Console.
(NOTE: Using a CMD Prompt will require the user name and password for the Database. If this information is unknown, the only option for correcting the Usage Log Error is Solution 1)
1. Open the system services (start>run>services.msc)
2. Locate the Bentley SELECTserver service, right click on it, and select properties.
3. Select the recovery tab from the tabs across the top.
4. Set the value for the first failure, second failure and subsequent failures to "restart the service."
5. Set the value for "Restart service after" to how ever long you think the machine takes to reboot. Generally 4-5 minutes is a good number.
Licensing TechNotes and FAQs
External Links Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to the "Comments" area below. THANK YOU!