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

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

Hello,

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

 

Hi beppe,

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

Hi, Their java problems please reinstell java and install again. I am shower your problem solved.

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 Panel > Administrator 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

What???

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/unable-generate-computer-status-report

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.

Hi,

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

 

Errror changed i have attached the error.

 

Kindly advise

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!!

Hi Jeshrel, you can try web console what is a errors come.

Hi Rafeeq & Sachin,

 

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

 

 

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?

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

 Hi Jeshrel,

any update can you try this steps.

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-generate-computer-status-report

 

I am stil not able to pull computer status report.

hi Jeshrel.

 

I think u try to repair the SEPM.

 

 

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

 

Hi James,

 

I get the error below

 

 

 

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

or

this is long time issue you can open support ticket.

Hi Sachin,

 

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

Hi James007,

 

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

Hi Guys,

 

I repaired SEPM 12.1.3 but still the same issue.

 

Need assistance to troubleshoot further.

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: https://support.broadcom.com (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...

Hi

If you use SQL database then enable Autogrowth in SQL

Regards

 

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?

Hi

Have u runthe Management Server

Regards

 

 

are all the previous months logs stored?