Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Unable to export computer status report

Created: 26 Aug 2013 • Updated: 07 Oct 2013 | 28 comments
Jeshrel's picture

Hi,

 

I am unable to pull computer status report from SEPM  12.1.3, i primarily had 12.1.2 so i upgraded to 12.1.3 but it is still unable to collect computer status report it just gives a blank screen. Need help

 

Error : File or directory not found

Troubeshoot Done:

1) Checked database connectivity. It' s good

2) Upgraded to 12.1.3

 

I provided my environment details before.

 

Environment: 

SEPM Server OS : 2003 Std SP2

SEPM : 12.1.3

SEP clients OS : Winodws XP and Windows 7

SEP : 11.0.4, 12.1.2

Operating Systems:

Comments 28 CommentsJump to latest comment

Jeshrel's picture

Hi,

 

Forgot to update

Troubeshoot Done:

1) Checked database connectivity. It' s good

2) Chhanged PHP value 

3) Reinstall Java

4) Upgraded to 12.1.3

Beppe's picture

Hello,

try to repair your SEP Manager installation from the Control Panel.

 

Regards,

Giuseppe

Jeshrel's picture

Hi beppe,

How would a repair fix the issue? please explain cause if i repair i need to expalin y?

Beppe's picture

A file is missing and the repair process is meant to replace missing/corrupted files

Regards,

Giuseppe

Sachin Sawant's picture

Hi,

Their java problems please reinstell java and install again.

I am shower your problem solved.

.Brian's picture

What???

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

sai_india's picture

Hi,

Testing the ODBC Connection

Note: On a 64-bit computer, a 32-bit DSN is created and is accessible via (by default) C:\Windows\SysWoW64\Odbcad32.exe.
 

  • For an embedded (Sybase) databaseFor an SQL database
    1. Verify that the Symantec Embedded Database service is running and that the dbsrv9.exeprocess is listening on TCP port 2638
    2. Test the ODBC connection.
      1. Open Control PaneAdministrator Tools
      2. Double click Data Sources (ODBC)
      3. On the System DSN tab, double-click SymantecEndpointSecurityDSN
      4. On the Database tab, type in the Server name (computer name) of your Manager, where the database resides. If computer name does not work, try the IP number or fully qualified domain name. (Version 11.0.5002.333 or newer, add SPC_ to the beginning of the server name. If the SPC_ prefix is not included, you will receive the error: "Database Server Not Found")
      5. On the Login tab, supply the user ID and password for the Symantec Embedded Database (defaults to the first admin password you ever used for the SEPM).

        User ID: dba
        Password: <password>

        Note: If the “Encrypt password” box on the Login tab is not checked, your password will be stored as plain text in the Windows registry.
         

      6. On the Network tab, confirm that TCP/IP is checked and the value has either HOST= or IP= with your server's IP (127.0.0.1 is also acceptable).
      7. Leave the defaults for the rest of the items and return to the ODBC tab
      8. Click Test Connection , it should return "Success"
      9. Click OK
    3. Verify the following:
      • You specified a named instance during installation and configuration. For example: \\<server name>\<instance name> 
      • The SQL Server is running and properly configured
      • The network connections between Symantec Endpoint Protection Manager and the SQL database. 
         
    4. Test the ODBC connection.
      1. Open Control Panel > Administrator Tools
      2. Double click Data Sources (ODBC)
      3. On the System DSN tab, double-click SymantecEndpointSecurityDSN
      4. Go through the wizard to ensure the following settings:

        Name: SymantecEndpointSecurityDSN
        Description: <Anything>
        Server: Servername\InstanceName (Only enter the server name or IP address if using the default instance)
        Login ID: sa
        Password: <password>
         

      5. Leave the defaults for the rest of the items and click Finish
      6. Click Test Data Source , it should return "Success"
      7. Click OK

 

can you perform the repair of SEPM from control panel/add-remove programs?

http://www.symantec.com/docs/HOWTO60763

Sachin Sawant's picture

Hello _Brian,

I am facing same problem that's why a give this command..

you are Trusted Advisor not Admin so behaver that advisor...

decided to admin what is correct or with wrong.

check this link for your reff.

https://www-secure.symantec.com/connect/forums/una...

.Brian's picture

I've already sent you a PM, you can respond to that so we can take this offline.

You are a Symantec partner and need to set a better example than what you've currently done.

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

Jeshrel's picture

Hi,

I re-insatlled Java ran a repair and rebooted my server.

 

Errror changed i have attached the error.

 

Kindly advise

10.132.100.55.JPG
Mithun Sanghavi's picture

Hello,

Basically this happens that for some reason when the database is not upgraded during the migration from a previous version .

In that case go to

\Program Files\Symantec\Symantec Endpoint Protection Manager\bin  (substitute Program Files (x86) in this path if working on a 64 bit system ) and run upgrade.bat then repair the SEP  manager installation through Control Panel - Add / Remove programs

Check this Article:

Query Failed returned on Home page in SEPM console after a successful migration from 11.0.6 to SEP 12.1

http://www.symantec.com/docs/TECH164854

Secondly, you can also try the below steps (incase you are using a SQL Database):

  1. Login to SQL Server Management Studio
  2. Expand the Server
  3. Expand Databases
  4. Expand sem5
  5. Expand Security
  6. Expand Users
  7. Right click sem5 and choose properties
  8. Select db_owner
  9. Restart Symantec Endpoint Protection Manager Service
  10. Login to console successfully and view all tabs.

Hope this works for you!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.

Rafeeq's picture

Give full permission to C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Inetpub\Reporting\Temp

The moment you click on view log from computer status or click export ( dont save just keep the export window open)

you should see alphanumeric excel report here in Temp. Does it get generated?

and .err files inside temp directory?

Sachin Sawant's picture

Hi Jeshrel,

you can try web console what is a errors come.

Jeshrel's picture

Hi Rafeeq & Sachin,

 

I wont be able to try these steps till this eve, shall do it and update you after that.

 

 

Sachin Sawant's picture

 Hi Jeshrel,

any update can you try this steps.

Jeshrel's picture

Hi Sachin,

 

I am still facing the same issue, i have tried all steps given above and also from

 

http://www.symantec.com/connect/forums/unable-gene...

 

I am stil not able to pull computer status report.

Sachin Sawant's picture

hi Jeshrel.

 

I think u try to repair the SEPM.

 

 

Jeshrel's picture

Hi Sachin,

 

A repair on SEPM was already performed but will do another one in a few hours.

James007's picture

are you loged in admin account or user account ?

check this articles

Query Failed in the Home tab.

 

Article:TECH140805  |  Created: 2010-09-28  |  Updated: 2012-08-18  |  Article URL http://www.symantec.com/docs/TECH140805

 

James007's picture

Did you try to repair sepm for add/remove program ?

or

this is long time issue you can open support ticket.

Jeshrel's picture

Hi James007,

 

I did perform one, but will do one again in a few hours

Jeshrel's picture

Hi Guys,

 

I repaired SEPM 12.1.3 but still the same issue.

 

Need assistance to troubleshoot further.

James007's picture

It's better you can open support ticket

How to create a new case in MySymantec

http://www.symantec.com/business/support/index?page=content&id=TECH58873

Phone numbers to contact Tech Support:-

Regional Support Telephone Numbers:

  • United States: 800-342-0652 (407-357-7600 from outside the United States)
  • Australia: 1300 365510 (+61 2 8220 7111 from outside Australia)
  • United Kingdom: +44 (0) 870 606 6000

Additional contact numbers: http://www.symantec.com/business/support/contact_t...

SameerU's picture

Hi

If you use SQL database then enable Autogrowth in SQL

Regards

 

Jeshrel's picture

Hi Sameer,

 

I do not have a SQL database.

 

After rebooting the server i am able to export computer status report for 

1) past 24 hours

2) past week

 

I am unabel to pull report for 

1) Past month

 

Any suggestions?

SameerU's picture

Hi

Have u runthe Management Server

Regards