Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
csv file not created using HHAppReport.exe tool!
 
  #1 (permalink)  
Old 06-22-2010, 10:55 PM
BES Administrator
 
Join Date: Jun 2010
Location: Toronto
Posts: 11
Question csv file not created using HHAppReport.exe tool!

After extracting the files and running the command to obtain apps on the bes handhelds
c:\....\hhappreport>hhappreport -n sqlservername -db besdbname -dbauth -o besappreport.csv

also tried with the path set to c:\

c:\....\hhappreport>hhappreport -n sqlservername -db besdbname -dbauth -o c:\besappreport.csv

I keep getting the hhappreport_log_xxxx.yxt file which says

Execution of query complete......
generating handheld application report.....
parsing data.........

BUT the csv file does not exist anywhere, nor does it open upon completion.

The dos window shows parsing data..and shows cursor in the correct place ie hhappreport>_ after finishing but no csv file!

I tried setting the path to d:\myappreport.csv but it still does not get generated!

any help would be appreciated!..BES v4.1.7 on Exchange.
I need to use dbauth as it needs username and password for SQL.

thank you
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 06-23-2010, 03:27 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

try running the command without specifying the output file. IIRC it'll create the file in the directory of the executable.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #3 (permalink)  
Old 06-26-2010, 11:41 PM
BES Administrator
 
Join Date: Jun 2010
Location: Toronto
Posts: 11
Default

Thanks..tried that also no csv file. Only HHAPPReport_Log_date.txt file with no reference to app info. Just general info and at end it says parsing data.
Reply With Quote
  #4 (permalink)  
Old 06-27-2010, 08:54 AM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

is the version of HHAppReport from the 4.1.7 BRK? Must make sure the version of the tool matches the version of the database.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #5 (permalink)  
Old 06-28-2010, 04:08 PM
BES Administrator
 
Join Date: Jun 2010
Location: Toronto
Posts: 11
Default

yes the tool kit is from RIM and matches the version that I am using
Reply With Quote
  #6 (permalink)  
Old 06-28-2010, 08:24 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

what version of the tool and what is the database version you're using?
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #7 (permalink)  
Old 07-06-2010, 10:47 AM
BES Administrator
 
Join Date: Jun 2010
Location: Toronto
Posts: 11
Default

Hi,
sorry for late reply..
using brk4.1.7.2.exe
BES v4.1.7.19 and
SQL (remote server) Enterprise Manager v8.0

thanks
Reply With Quote
  #8 (permalink)  
Old 07-06-2010, 10:50 AM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

Ok, I know this goes against everything I've said, however try the 4.1.6 BRK and then post the results in HHAppReport_Log_20100706_XXXX.txt too
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #9 (permalink)  
Old 07-08-2010, 11:02 AM
BES Administrator
 
Join Date: Jun 2010
Location: Toronto
Posts: 11
Default

ok let me try..
Reply With Quote
  #10 (permalink)  
Old 07-08-2010, 05:30 PM
BES Administrator
 
Join Date: Jun 2010
Location: Toronto
Posts: 11
Default

No luck im afraid. Used brk4.1.6.8.exe
specified it two ways with/without the file path.
c:\....\hhappreport>hhappreport -n sqlservername -db besdbname -dbauth -o c:\besappreport.csv
and
c:\....\hhappreport>hhappreport -n sqlservername -db besdbname -dbauth -o besappreport.csv

Only get the log text file in the hhappreport folder where the hhappreport executable resides. Here is the last lines of the text file ....

40000] (07/08 17:23:54.239):{0x2488} BlackBerry(R) Application Reporting
Tool
[40000] (07/08 17:23:54.239):{0x2488} BlackBerry(R) Application Reporting
Tool Version 4.1.6.4
[40000] (07/08 17:23:54.239):{0x2488} Modification date: Jul 23 2008
[40000] (07/08 17:23:58.958):{0x2488} Login: besadmin
[20000] (07/08 17:24:03.505):{0x2488} Connecting to Configuration
Database...
[20000] (07/08 17:24:03.598):{0x2488} Connected to Configuration Database.
[20000] (07/08 17:24:03.598):{0x2488} Executing Configuration Database
Query...
[40000] (07/08 17:24:03.598):{0x2488} SQL Statement Executed: "SELECT
DISTINCT mytable.data FROM (SELECT SUBSTRING(Data,1,DATALENGTH(Data)) AS
data FROM SyncDeviceMgmt WHERE (TableId = 2)) mytable "
[20000] (07/08 17:24:07.645):{0x2488} Execution of Query complete.
[20000] (07/08 17:24:07.645):{0x2488} Generating Handheld Application
Report...
[20000] (07/08 17:24:07.645):{0x2488} Parsing Data...

thanks for your help
Reply With Quote
  #11 (permalink)  
Old 07-08-2010, 05:34 PM
BES Administrator
 
Join Date: Jun 2010
Location: Toronto
Posts: 11
Default

Here is all the txt file in addition to the above when output is to c:\

UTF-8 encoded
[30000] (07/08 17:23:54.145):{0x124C} Current Date: 2010/07/08
[30000] (07/08 17:23:54.145):{0x124C} [DIAG] EVENT=Thread_report,
THREADID=0x124C, THREADNAME="DebugLogger"
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Current Process: E:\tools
\besexchextract\HHAppReport\HHAppReport.exe
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Current Process logged on as:
LBG\icva012, Start Time: Jul 08 2010 17:23:54, Uptime (seconds): 0
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Current Process id: 9960
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Computer Host Name:
SFWPCDNMSG027, OS Version: 5.2, Build number 3790, ServicePack Major 2,
ServicePack Minor 0
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Processor Identifier: x86
Family 6 Model 15 Stepping 6
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Processor Vendor Identifier:
GenuineIntel
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Processor Name String: Intel(R)
Xeon(R) CPU 5140 @ 2.33GHz
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Number of Processors: 2
[30000] (07/08 17:23:54.145):{0x124C} [ENV] 84 percent of memory in use.
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Total size of physical memory:
2096412 KB
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Size of physical memory
available: 332520 KB
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Size of the committed memory
limit: 4728188 KB
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Size of available memory to
commit: 2583316 KB
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Total size of the user mode
portion of the virtual address space of the BES process: 2097024 KB
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Size of unreserved and
uncommitted memory in the user mode portion of the virtual address space of
the BES process: 2075900 KB
[30000] (07/08 17:23:54.145):{0x124C} [ENV] Total HD bytes: 114462994432,
Total free bytes = 16591691776
[30000] (07/08 17:23:54.161):{0x124C} [ENV] System up time: 12 days 12 hrs
02 mins 13 secs
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Local Time Zone: Eastern
Daylight Time (GMT-05:00)
[30000] (07/08 17:23:54.161):{0x124C} [ENV] TCP/IP provider (Winsock) File
Version: 5.2.3790.0 (C:\WINDOWS\System32\wsock32.dll)
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Unable to provide HostName
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Winsock2 file: Network Location
Awareness (NLA) Namespace, Version: 5.2.3790.4318 (C:\WINDOWS\System32
\mswsock.dll)
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Microsoft XML Parser 6.0:
C:\WINDOWS\system32\msxml6.dll, Version: 6.20.2003.0
[30000] (07/08 17:23:54.161):{0x124C} [ENV] MDAC version: 2.82.3959.0
[30000] (07/08 17:23:54.161):{0x124C} [ENV] MSADO15.DLL: C:\Program Files
\Common Files\System\ado\msado15.dll, Version: 2.82.3959.0
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: System
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: smss.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: csrss.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: winlogon.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: services.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: lsass.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: ati2evxx.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: svchost.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: svchost.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: svchost.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: svchost.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: svchost.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: spoolsv.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: msdtc.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process: aqagent.exe
[30000] (07/08 17:23:54.161):{0x124C} [ENV] Running Process:
BBAttachServer.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: bcol.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: bmds.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: BESAlert.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: casdscsvc.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: UnivAgent.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
cimlistener.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: DWRCS.EXE
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: svchost.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: IBMIASRW.EXE
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: IBMSA.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: IBMSPSVC.EXE
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: slp_srvreg.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: jacservice.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: IBMSPREM.EXE
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: IBMSPREM.EXE
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: jqs.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: lcfd.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: LogWatNT.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
FrameworkService.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
lic98Service.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: Mcshield.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: VsTskMgr.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: MDSGateway.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
javaservice.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
miniwinagent.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: svchost.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: RaidServ.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: srmservice.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: tier1slp.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: winvnc.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: wmicimsv.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: unsecapp.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: wmiprvse.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
BlackBerryController.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: wmippa.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: wmicpa.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
BlackBerryDispatcher.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
ITAdminServer.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
BlackberryRouter.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
BlackBerryAgent.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
BlackBerryAgent.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
BlackBerryAgent.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: ibmsprdp.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: svchost.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: wmiprvse.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: Tmw2k.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: svchost.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: csrss.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: winlogon.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: ati2evxx.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: logon.scr
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
BlackBerryAgent.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: naPrdMgr.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
BlackBerrySyncServer.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: srmagent.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: csrss.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: winlogon.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: rdpclip.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: explorer.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: jusched.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: shstat.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: iexplore.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: java.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: rdpclip.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: explorer.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: jusched.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: shstat.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: oobechk.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: mshta.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: wuauclt.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: DWRCST.EXE
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: BBConvert.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: BBConvert.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: cmd.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: BBConvert.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: BBConvert.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: CalHelper.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: BBConvert.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process: CalHelper.exe
[30000] (07/08 17:23:54.176):{0x124C} [ENV] Running Process:
HHAppReport.exe
[40000] (07/08 17:23:54.239):{0x2488} BlackBerry(R) Application Reporting
Tool
[40000] (07/08 17:23:54.239):{0x2488} BlackBerry(R) Application Reporting
Tool Version 4.1.6.4
[40000] (07/08 17:23:54.239):{0x2488} Modification date: Jul 23 2008
[40000] (07/08 17:23:58.958):{0x2488} Login: besadmin
[20000] (07/08 17:24:03.505):{0x2488} Connecting to Configuration
Database...
[20000] (07/08 17:24:03.598):{0x2488} Connected to Configuration Database.
[20000] (07/08 17:24:03.598):{0x2488} Executing Configuration Database
Query...
[40000] (07/08 17:24:03.598):{0x2488} SQL Statement Executed: "SELECT
DISTINCT mytable.data FROM (SELECT SUBSTRING(Data,1,DATALENGTH(Data)) AS
data FROM SyncDeviceMgmt WHERE (TableId = 2)) mytable "
[20000] (07/08 17:24:07.645):{0x2488} Execution of Query complete.
[20000] (07/08 17:24:07.645):{0x2488} Generating Handheld Application
Report...
[20000] (07/08 17:24:07.645):{0x2488} Parsing Data...
Reply With Quote
  #12 (permalink)  
Old 07-14-2010, 07:30 AM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

the last line in the report is:

[20000] (07/08 17:24:07.645):{0x2488} Parsing Data...

? Nothing after that at all?
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #13 (permalink)  
Old 07-14-2010, 02:40 PM
BES Administrator
 
Join Date: Jun 2010
Location: Toronto
Posts: 11
Default

Hi,
nope it just stops there. All data is shown above.
The same last line is showing after i run it many times with or without the full file path c:\ etc.
Reply With Quote
  #14 (permalink)  
Old 07-15-2010, 06:31 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

Ok I'm stumped ... is the DB on the same server that you're executing this command on? if not ... I'd try running it locally on the DB server.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #15 (permalink)  
Old 07-16-2010, 03:56 PM
BES Administrator
 
Join Date: Jun 2010
Location: Toronto
Posts: 11
Default

im running it on the bes server, the toolkit is extracted on the bes server, the sql server is remote. Are you saying try running it on the sql server?
Reply With Quote
  #16 (permalink)  
Old 07-25-2010, 02:12 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

ok, I thought I replied to this one. yes, on SQL.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
BlackBerry Expert Support Tool Joolie Scripts & Tools / Hints & Tricks 4 11-15-2009 12:13 PM
BES 5.0 User Administration Tool Setup tmunro55 Port 3101: The BES Admin Bar & Grill 4 11-03-2009 12:42 PM
KB05338 - BippePassword entries are not created in the registry hdawg Featured BlackBerry KB Articles 0 04-01-2009 03:16 PM
KB12300 - Using the SetSendAsPermission tool hdawg Featured BlackBerry KB Articles 0 02-08-2009 01:14 PM
Tool to do what OSClean did knottyrope Scripts & Tools / Hints & Tricks 2 01-20-2009 03:17 PM


All times are GMT -4. The time now is 09:23 PM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2