swaters86

2015-07-13 12:48:43,009 | ERROR | DevExpress.Xpo.DB.Exceptions.UnableToCreateDBObjectException: Unable to create 'ForeignKey' 'FK_CG_Flex1Ticket_UDF_ForwardEmail'. Parent: 'CG_Flex1Ticket'. Error: Executing Sql 'alter table "dbo"."CG_Flex1Ticket" add constraint "FK_CG_Flex1Ticket_UDF_ForwardEmail" foreign key ("UDF_ForwardEmail") references "dbo"."CG_Principal"("OID") NOT FOR REPLICATION' with parameters '' exception 'System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_CG_Flex1Ticket_UDF_ForwardEmail' in the database.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at S

swaters86

2015-03-10 16:20:54,473 | ERROR | System.InvalidOperationException: Cross-thread operation detected. 'XPOPersistenceService.XPOSession(24227)' is not a thread-safe object, please avoid using it simultaneously from different threads
   at DevExpress.Xpo.Helpers.SessionStateStack.Enter(Session session, SessionState newState)
   at DevExpress.Xpo.Helpers.ObjectCollectionLoader.LoadObjects(ObjectsQuery[] queries)
   at DevExpress.Xpo.SimpleObjectLayer.LoadObjects(Session session, ObjectsQuery[] queries)
   at DevExpress.Xpo.SimpleObjectLayer.GetObjectsByKey(Session session, ObjectsByKeyQuery[] queries)
   at DevExpress.Xpo.Session.GetObjectByKey(XPClassInfo classInfo, Object id, Boolean alwaysGetFromDb)
   at DevExpress.Xpo.Session.GetObjectByKey(Type classType, Object id, Boolean alwaysGetFromDb)
   at XPOPersistenceService.XPOPersistenceManager.GetObjectForEdit(IUserSession uSession, IUnitOfWork unitOfWork, Type entityType, Int32 key)
   at ApplicationServices.EntityHandlers.EntityHandler.GetObjectForEdit(IUser

swaters86

2015-03-17 15:22:47,045 | ERROR | Could not get object from DB.
System.InvalidOperationException: Cross-thread operation detected. 'XPOPersistenceService.XPOSession(95269)' is not a thread-safe object, please avoid using it simultaneously from different threads
   at DevExpress.Xpo.Helpers.SessionStateStack.Enter(Session session, SessionState newState)
   at DevExpress.Xpo.Helpers.ObjectCollectionLoader.LoadObjects(ObjectsQuery[] queries)
   at DevExpress.Xpo.SimpleObjectLayer.LoadObjects(Session session, ObjectsQuery[] queries)
   at DevExpress.Xpo.SimpleObjectLayer.GetObjectsByKey(Session session, ObjectsByKeyQuery[] queries)
   at DevExpress.Xpo.Session.GetObjectByKey(XPClassInfo classInfo, Object id, Boolean alwaysGetFromDb)
   at DevExpress.Xpo.Session.GetObjectByKey(Type classType, Object id, Boolean alwaysGetFromDb)
   at XPOPersistenceService.XPOPersistenceManager.GetObjectFromDB(IUserSession usrSession, IUnitOfWork unitOfWork, Type type, Int32 key)
2015-03-17 15:22:48,465 | ERROR | Could not get obje

swaters86

SQL Server Process CPU Utilization	System Idle Process	Other Process CPU Utilization	Event Time
47	49	4	2015-03-05 08:28:19.993
50	44	6	2015-03-05 08:27:19.993
5	88	7	2015-03-05 08:26:19.990
4	91	5	2015-03-05 08:25:19.983
4	91	5	2015-03-05 08:24:19.983
4	91	5	2015-03-05 08:23:19.983
3	92	5	2015-03-05 08:22:19.983
3	93	4	2015-03-05 08:21:19.983
3	93	4	2015-03-05 08:20:19.983

swaters86

	/*
	select * 
	from web.dbo.Artikkler_tekst (nolock) 
	where Avis='la' and Lopenr='150309826' and Dato='20150303' and blokk=1
	*/

	/* Declare Site Code Variable */
	declare @ASite varchar(2)

swaters86

// ==UserScript==
// @name        Display Site Information
// @namespace   DSI
// @description Overlays Infomration on Website
// @include     http://*.dailynews.com/*
// @include     http://*.presstelegram.com/*
// @include     http://*.sgvtribune.com/*
// @include     http://*.pasadenastarnews.com/*
// @include     http://*.whittierdailynews.com/*
// @include     http://*.dailybulletin.com/*

swaters86

/*sports*/
select top 200 t.Profile_ID, t.Name, t.Parent_id, case when exists (select p.avis from web.dbo.profile p (nolock) where p.Avis = t.Avis and p.Parent_id = t.Profile_id) then 1 else 0 end as Children, case when IsNull(relp.url , '') <> '' then relp.url else IsNull(t.URL, '')   end as URL,  case    when IsNull(relp.TargetURL , '') <> '' then relp.TargetURL else IsNull(t.TargetURL, '') end as TargetURL, case when ISNULL(relp.TargetCategory, '') <> '' then relp.TargetCategory else IsNull(t.TargetCategory, '') end as TargetCategory, web.dbo.fGetProfileLevel('GA','1875') as Sublevel from web.dbo.Profile t (nolock)   left join  webextras.dbo.profile_extrafields ext (nolock) on (ext.Avis=t.Avis and ext.ProfileID=t.profile_id and ext.Varname='ProfileIDRef')  left join web.dbo.profile relp (nolock)    on (relp.Avis=t.Avis and relp.profile_id=cast(ext.VarValue as int)) where t.Avis = 'GA' and t.Profile_ID > 0 and t.Parent_ID = '1875'   and t.Profile_ID NOT IN (SELECT [ProfileID]                            FROM

swaters86

CCE Objects Deleted
===========================================
Site   GUID
-------------------------------------------
An error has occurred! #8134
Divide by zero error encountered.
DL     55D76001-50DD-4DB4-920E-56067E51A351
 
An error has occurred! #8134
Divide by zero error encountered.

swaters86

select * 
from webextras.dbo.SEOLabels (nolock) 
where SEOLabel like '%ex-pasadena-employee-accused-of-embezzling-64-million-has-bail-reduced%'


/*
update 
webextras.dbo.SEOLabels 
set ItemGUID='9AD5D51C-6788-434E-9D53-4AED5D6996CF', Revision=0
where ItemGUID='1A9C9037-6B44-4DE3-A519-4C94647A70DF'

swaters86

SETTINGS]
IgnoreDBVersionOnErrors=1
SAXOLog=1
;SAXOLogDebugElements=ConnectionPool,FastQueries,CCETagTiming,SolrQueries
SaxoLogDebugElements=OWSRequests
SAXOLogFlushInterval=5
SAXOLogLogLevel=debug