Sage Line 500 User Activity Data
Published May 08, 2020 / by Chris Smith / Leave a CommentSage Line 500 ERP maintains user activity data in: DATABASE_SERVER.csmaster.scheme.uar
CJSmith dot me
I dump stuff I find useful here
Tidy Sage Line 500 ERP Temporary Tables via TSQL
Published February 16, 2020 / by Chris Smith / Leave a CommentThe official Sage Help has a select statement to delete temporary tables, but doesn’t allow an automated way to remove. This script will delete tables so you must take extra care, I recommend trialing this on your Development Sage ERP system first. Review every step and when you are happy Commit the transactions (If run […]
Avoid error “2427 You entered an expression that has no value” when passing a parameter to a form
Published February 16, 2020 / by Chris Smith / Leave a CommentTo avoid getting an error when passing a variable to a form, using If Not against the EOF (I believe means End of File) property. If Not Me.Recordset.EOF And Not Me.Recordset.EOF Then Dim stDocName As String Dim stLinkCriteria As String stDocName = “someform” stLinkCriteria = “[recordnumber]=” & Me.[recordnumber] DoCmd.OpenForm stDocName, , , stLinkCriteria Else MsgBox […]
Arcsoft Totalmedia Extreme causing issues upgrading to Windows 10 Version 1909
Published December 29, 2019 / by Chris Smith / Leave a CommentI recently had fun with being unable to upgrade to version 1909 for Window 10 failing with a BSOD and an error which pointed to a memory issue. After using Nirsoft’s BSOD ViewNirsoft’s BSOD View it pointed to ArcSec.sys. I uninstalled Arcsoft Totalmedia Extreme. however the uninstaller left the drivers installed. I then used SysInternals […]
Powershell issue with output characters changing to ?
Published September 29, 2019 / by Chris Smith / Leave a CommentOn PowerShell command pipe to export CSV add Encoding Unicode if characters change to ? Credit: Idera execute xp_cmdshell ‘powershell -Command “Get-ChildItem -File -Path @path -filter *.* -Recurse | ForEach-Object {[PsCustomObject]@{Fullname = “$($_.FullName)”; LastWriteTime = “$($_.LastWriteTime)”}} | Sort Fullname -Descending | Export-Csv -Path @CSVFile -NoTypeInformation -Encoding unicode”‘ If using BULK INSERT ensure widechar is used […]
Windows 2008 – Alert on Scheduled Job Failure
Published August 11, 2019 / by Chris Smith / Leave a CommentFirst we need to enable logging for the Windows Task Scheduler, open Event Viewer (Put “eventvwr.msc” in Run) and browse to TaskScheduler as below. Right click the Operational log and click properties and ensure the “Enable Logging” is checked Windows is now setup to log Scheduled tasks to the Event Viewer, now we need to […]
Mail on Login failure to a Microsoft SQL Server
Published August 11, 2019 / by Chris Smith / Leave a CommentEnsure a mail profile is setup and make a note of its name. Run the following in Microsoft Query Analyser replacing the mail profile and email address. USE [msdb] GO /* Credit https://sqljunkieshare.com/2016/08/01/variable-wmi-not-found/ for issue with Variable WMI Not Found on newer versions of SQL Server */ EXEC msdb.dbo.sp_set_sqlagent_properties @alert_replace_runtime_tokens = 1 GO USE [msdb] […]
Sage Line 500 V7.1 CSAgent TCR and Form appear to start but ports never open
Published July 20, 2019 / by Chris Smith / Leave a CommentRecently we had this issue where after windows patches were applied, after a reboot the Sage Line 500 v7.1 Windows services no longer worked on our development and live servers. It was due to the Visual Studio dll msvcr71.dll being removed SYSWOW64 (32 Bit systems will be System32 and you can see in process monitor […]
Populate Sage table opheadm with credit note information for Cindercone Magma to send to Tungsten/OB10
Published June 09, 2019 / by Chris Smith / Leave a CommentThe below stored proc is used to populate two Sage fields shipper_code2 and shipper_code3 in the Order Header Table. Obiously if this is used already by another Sage Project do not use, as the fields won’t be updated. Here I look 30 days backwards and at particular invoice customers (There is no point updating every […]
Force TSQL dateformat
Published June 09, 2019 / by Chris Smith / Leave a CommentIf you get the following error on scheduled stored procedures, force the dateformat (The Microsoft SQL Server scheduler will probably be running the default mdy), you can use Set Language but I tend to change the dateformat. [SQLSTATE 01000] (Message 0) The conversion of a nvarchar data type to a datetime data type resulted in […]