tracker issue : CF-3991862

select a category, or use search below
(searches all categories and all time range)
Title:

Log Activity in "Data & Services > Datasources > Microsoft SQL Server" doesn't work

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): Henry Ho / Henry Ho (Henry Ho)

Created: 05/20/2015

Components: Database

Versions: 10.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Windows 7 SP1 64-bit

Vote Count: 0

Problem Description: "Log database calls to (anywhere)" doesn't work in CF Admin's Data & Services > Datasources > Microsoft SQL Server.

Steps to Reproduce: Add a new data source, turn on Log Activity and set log database calls to anywhere

Actual Result: No file is created, nothing's logged anywhere.

Expected Result: something's logged to the path set to the path

Any Workarounds: none.  Restarted, still doesn't work.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3991862

External Customer Info:
External Company:  
External Customer Name: Henry
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

Henry, It seems to be working fine at our end. Can you please settings summary of ColdFusion server?
Comment by Nimit S.
7356 | June 04, 2015 11:58:08 PM GMT
settings summary printed to PDF, see attachment.
Comment by External U.
7357 | June 05, 2015 12:33:50 PM GMT
Hi Henry, Settings summary which is attached to this bug, does not have data source details. Please follow below given step to save settings summary as pdf. CF Admin > Server Settings > Settings Summary > Save As PDF
Comment by Nimit S.
7358 | June 24, 2015 04:02:32 AM GMT
done, see: serversettings.pdf
Comment by External U.
7359 | June 24, 2015 11:25:23 AM GMT
Hi Henry, As per settings summary, it looks like you have not given filename for spy log. Can you please try providing filename along with "D:/"? Please let me know if it works.
Comment by Nimit S.
7360 | June 24, 2015 10:39:33 PM GMT
@NimitSharma It works now. Thanks. I think it is misleading because "Browse Server" only populates the input field with a path to a folder. Different issue, but the log often only shows PreparedStatement[xxxx]. How to find out what's what? Please remove the attached pdf's in this ticket.
Comment by External U.
7361 | June 25, 2015 12:32:25 PM GMT
Hi Henry, I am glad your issue is resolved. Can you please log an enhancement for "Browse Server"? Please share spy log at nimsharm@adobe.com so that I can look at it and give you some insight. I have also removed settings summary from this bug. Thanks, Nimit
Comment by Nimit S.
7362 | June 25, 2015 11:41:52 PM GMT