tag:help-archives.hannonhill.com,2010-02-09:/discussions/installation/4006-warn-at-startup-after-upgrade-from-6109-to-7142Cascade CMS: Discussion 2015-02-17T13:17:39Ztag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-12T12:48:52Z2015-02-12T13:41:02ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Dear all,</p>
<p>After upgrading from 6.10.9 to 7.14.2, I still have the
following WARN during each startup(see complete stacktrage
attached) :</p>
<pre>
<code> [StartupTasks] *** Running startup task: OptimizeStructuredDataStartupTask
2015-02-12 13:41:55,033 INFO [OptimizeDatabaseServiceImpl] Clearing orphaned assets...
2015-02-12 13:41:55,033 INFO [OptimizeDatabaseServiceImpl] Clearing orphaned Data Definition nodes...
2015-02-12 13:41:55,048 INFO [OptimizeDatabaseServiceImpl] Deleted 0 orhpaned Data Definition nodes
2015-02-12 13:41:55,049 INFO [OptimizeDatabaseServiceImpl] Finished clearing 0 orphaned Data Definition node record(s)
2015-02-12 13:41:55,049 INFO [OptimizeDatabaseServiceImpl] Fixing Structured Data with missing owner entity property
2015-02-12 13:41:55,053 INFO [OptimizeDatabaseServiceImpl] Found 23 broken Structured Data nodes
2015-02-12 13:41:55,407 WARN [StartupTasks] Startup task: OptimizeStructuredDataStartupTask failed to execute successfully but will not prevent login. Exception is as follows:
com.hannonhill.cascade.model.dao.exception.DomainObjectValidationException: A domain object failed validation
1 total errors...
Error detail:
Object name: com.hannonhill.cascade.model.dom.StructuredData@606e8697[type=structureddata,id=d487a5a3c0a8644201aa09332cda8d82]
Global errors:
Field errors:
field: name
field.required.com.hannonhill.cascade.model.dom.StructuredData@606e8697[type=structureddata,id=d487a5a3c0a8644201aa09332cda8d82].name
field.required.name
field.required.java.lang.String
field.required</code>
</pre>
<p>Could you please help us solving this problem, what should be
the steps ? Is it problematic for our instance ?</p>
<p>Thanks a lot for your help,</p>
<p>Best regards,</p>
<p>Benoît</p></div>Benoîttag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-12T14:19:55Z2015-02-12T14:19:55ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Hi Benoît,</p>
<p>I think a good starting point would be for us to have a look at
the record in the database for the item that appears to be causing
issues. When you have a moment, can you please execute the
following SQL queries and attach the results from each one as a
file?</p>
<pre>
<code>select * from cxml_structureddata where id = 'd487a5a3c0a8644201aa09332cda8d82';</code>
</pre>
<pre>
<code>select * from cxml_structureddata where name is null;</code>
</pre>
<p>Thanks!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-12T16:07:50Z2015-02-12T16:07:50ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Hi Tim,</p>
<p>Thanks for your reply,<br>
I attached the result of the two sql querie's results in the
response.</p>
<p>Should I eventually delete the row matchind the id ?</p>
<p>Thanks,</p>
<p>Benoît</p></div>Benoîttag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-12T16:24:17Z2015-02-12T16:24:17ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Thanks for the information, Benoît. Let me look over these
results with my developers and I'll let you know what the next
course of action should be.</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-12T19:56:59Z2015-02-12T19:56:59ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Benoît,</p>
<p>When you have a moment, please do the following:</p>
<ul>
<li>Click <strong>System Menu -> Utilities -> Database Tools
-> Optimize Database</strong></li>
<li>On the next screen, check <strong>ONLY</strong> the option
<strong>Remove orphaned records</strong> (leave the rest
unchecked)</li>
<li>Click Submit</li>
</ul>
<p>Once that completes, let me know if you're still seeing that
warning message on startup.</p>
<p>Thanks!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-13T16:36:45Z2015-02-13T16:36:46ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Thanks for your reply !</p>
<p>I did the Optimization like you described. (See logs attached).
But we still have the same WARN at startup. Does the Repair
Structured Data checkbox would help ?</p>
<p>Many thanks for your support,</p>
<p>Best regards,</p>
<p>Benoît</p></div>Benoîttag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-13T20:43:39Z2015-02-13T20:43:39ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>You can try running that option as well if you'd like. It may do
the trick, but I would have thought that the 'remove orphaned
records' option would work (since that's essentially what these
records are in your database).</p>
<p>Let me know if that option resolves the issue. If not, we can
look into providing you with queries to safely remove them from
your database.</p>
<p>Thanks!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-16T10:20:20Z2015-02-16T10:20:21ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Hello,</p>
<p>I tried the "Repair Structured Data" and it raises directly the
error in the logs (see attached).</p>
<p>That would be great if you could provide me a safe way to remove
the entry causing the trouble.</p>
<p>Many thanks,</p>
<p>Benoît</p></div>Benoîttag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-16T18:52:06Z2015-02-16T18:52:06ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Benoît,</p>
<p>When you have a moment, please try the following:</p>
<ul>
<li>Create a backup of your database (just to be safe!)</li>
<li>Execute the following SQL query:
<pre>
<code>update cxml_structureddata set name='temp' where name is null;</code>
</pre></li>
<li>Restart Cascade Server and check for the warning messages</li>
</ul>
<p>Let me know if that does the trick.</p>
<p>Thanks!</p></div>Timtag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-17T09:32:38Z2015-02-17T09:32:39ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Hi Tim,</p>
<p>Thanks for the query, it took 7 minutes to be executed and
updated 10 records.</p>
<p>The WARN disappeared from the logs.</p>
<p>Many Thanks,</p>
<p>Benoît</p></div>Benoîttag:help-archives.hannonhill.com,2010-02-09:Comment/360298132015-02-17T13:17:37Z2015-02-17T13:17:37ZWarn at startup after upgrade from 6.10.9 to 7.14.2<div><p>Perfect. Glad to hear that did the trick, Benoît. Take
care!</p></div>Tim