This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
I am attempting to use Migration Manager to migrate tables from DEV to QA environment. I sine scoped it down to do one table. I am getting the above error and can not find anything that could be causing it.
BMXAA5617E - When text search is enabled, a language column name must be specified.
The table I am migrating is not Tex Search enabled and none of the columns on the table are Search Type TEXT. I have checked that all data is in order in all the following tables
/***********************************************************************/
select *
from "MAXIMO"."MAXATTRIBUTE"
where objectname like 'STR\_%'ESCAPE '\' and searchtype = 'TEXT';
select *
from "MAXIMO"."MAXATTRIBUTECFG"
where objectname like 'STR%' and searchtype = 'TEXT';
/***********************************************************************/
select *
from "MAXIMO"."MAXOBJECTCFG"
where objectname like 'STR\_%'ESCAPE '\';
select *
from "MAXIMO"."MAXOBJECT"
where objectname like 'STR\_%'ESCAPE '\';
/***********************************************************************/
select tablename, textsearchenabled, langtablename, langcolumnname, islangtable
from "MAXIMO"."MAXTABLECFG"
where tablename like 'STR%';
select tablename, textsearchenabled, langtablename, langcolumnname, islangtable
from "MAXIMO"."MAXTABLE"
where tablename like 'STR%';
/***********************************************************************/
Here is the XML of the Error:
<MAXOBJECTCFG xmlns="http://www.ibm.com/maximo" action="AddChange">
<CHANGED>N</CHANGED>
<CLASSNAME>psdi.pluss.mbo.SDEMboSet</CLASSNAME>
<DESCRIPTION>GIS Retaining Wall Structures</DESCRIPTION>
<EAUDITENABLED>0</EAUDITENABLED>
<EAUDITFILTER />
<EAUDITTBNAME />
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGFILTER />
<EXTENDSOBJECT />
<IMPORTED>0</IMPORTED>
<INTERNAL>0</INTERNAL>
<ISAUDITTABLE>0</ISAUDITTABLE>
<ISVIEW>0</ISVIEW>
<MAINOBJECT>0</MAINOBJECT>
<MAXOBJECTID>2057</MAXOBJECTID>
<OBJECTNAME>STR_RETAINING_WALL</OBJECTNAME>
<PERSISTENT>1</PERSISTENT>
<SERVICENAME>CUSTAPP</SERVICENAME>
<SITEORGTYPE maxvalue="SYSTEM">SYSTEM</SITEORGTYPE>
<STORAGEPARTITION>MAXDATA</STORAGEPARTITION>
<TEXTDIRECTION />
<TEXTSEARCHENABLED>0</TEXTSEARCHENABLED>
<TRIGROOT>STR_RETAINING_WALL</TRIGROOT>
<UNIQUECOLUMNNAME>OBJECTID</UNIQUECOLUMNNAME>
<USERDEFINED>1</USERDEFINED>
<MAXTABLECFG>
<ADDROWSTAMP>0</ADDROWSTAMP>
<ALTIXNAME />
<CONTENTATTRIBUTE />
<EAUDITTBNAME />
<ISAUDITTABLE>0</ISAUDITTABLE>
<ISLANGTABLE>0</ISLANGTABLE>
<MAXTABLEID>1430</MAXTABLEID>
<RESTOREDATA>0</RESTOREDATA>
<STORAGEPARTITION>MAXDATA</STORAGEPARTITION>
<TABLENAME>STR_RETAINING_WALL</TABLENAME>
<TEXTSEARCHENABLED>0</TEXTSEARCHENABLED>
<TRIGROOT>STR_RETAINING_WALL</TRIGROOT>
<UNIQUECOLUMNNAME>OBJECTID</UNIQUECOLUMNNAME>
</MAXTABLECFG>
<MAXATTRIBUTECFG>
<ALIAS>MXASSETNUM</ALIAS>
<ATTRIBUTENAME>MXASSETNUM</ATTRIBUTENAME>
<ATTRIBUTENO>2</ATTRIBUTENO>
<AUTOKEYNAME />
<CANAUTONUM>1</CANAUTONUM>
<CHANGED>N</CHANGED>
<CLASSNAME />
<COLUMNNAME>MXASSETNUM</COLUMNNAME>
<COMPLEXEXPRESSION />
<DEFAULTVALUE />
<DOMAINID />
<EAUDITENABLED>0</EAUDITENABLED>
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGENABLED>0</ESIGENABLED>
<HANDLECOLUMNNAME />
<ISLDOWNER>0</ISLDOWNER>
<ISPOSITIVE>0</ISPOSITIVE>
<LENGTH>12</LENGTH>
<LOCALIZABLE>0</LOCALIZABLE>
<MAXATTRIBUTEID>69561</MAXATTRIBUTEID>
<MAXTYPE>UPPER</MAXTYPE>
<MLINUSE>0</MLINUSE>
<MLSUPPORTED>0</MLSUPPORTED>
<MUSTBE>0</MUSTBE>
<PERSISTENT>1</PERSISTENT>
<PRIMARYKEYCOLSEQ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
<REMARKS>Mxassetnum</REMARKS>
<REQUIRED>0</REQUIRED>
<RESTRICTED>0</RESTRICTED>
<SAMEASATTRIBUTE>ASSETNUM</SAMEASATTRIBUTE>
<SAMEASOBJECT>ASSET</SAMEASOBJECT>
<SCALE>0</SCALE>
<SEARCHTYPE>WILDCARD</SEARCHTYPE>
<SEQUENCENAME />
<TEXTDIRECTION />
<TITLE>Mxassetnum</TITLE>
<USERDEFINED>1</USERDEFINED>
</MAXATTRIBUTECFG>
<MAXATTRIBUTECFG>
<ALIAS>MXSITEID</ALIAS>
<ATTRIBUTENAME>MXSITEID</ATTRIBUTENAME>
<ATTRIBUTENO>3</ATTRIBUTENO>
<AUTOKEYNAME />
<CANAUTONUM>0</CANAUTONUM>
<CHANGED>N</CHANGED>
<CLASSNAME>psdi.app.site.FldSiteID</CLASSNAME>
<COLUMNNAME>MXSITEID</COLUMNNAME>
<COMPLEXEXPRESSION />
<DEFAULTVALUE />
<DOMAINID />
<EAUDITENABLED>0</EAUDITENABLED>
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGENABLED>0</ESIGENABLED>
<HANDLECOLUMNNAME />
<ISLDOWNER>0</ISLDOWNER>
<ISPOSITIVE>0</ISPOSITIVE>
<LENGTH>8</LENGTH>
<LOCALIZABLE>0</LOCALIZABLE>
<MAXATTRIBUTEID>69564</MAXATTRIBUTEID>
<MAXTYPE>UPPER</MAXTYPE>
<MLINUSE>0</MLINUSE>
<MLSUPPORTED>0</MLSUPPORTED>
<MUSTBE>0</MUSTBE>
<PERSISTENT>1</PERSISTENT>
<PRIMARYKEYCOLSEQ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
<REMARKS>Mxsiteid</REMARKS>
<REQUIRED>0</REQUIRED>
<RESTRICTED>0</RESTRICTED>
<SAMEASATTRIBUTE>SITEID</SAMEASATTRIBUTE>
<SAMEASOBJECT>SITE</SAMEASOBJECT>
<SCALE>0</SCALE>
<SEARCHTYPE>WILDCARD</SEARCHTYPE>
<SEQUENCENAME />
<TEXTDIRECTION />
<TITLE>Mxsiteid</TITLE>
<USERDEFINED>1</USERDEFINED>
</MAXATTRIBUTECFG>
<MAXATTRIBUTECFG>
<ALIAS>OBJECTID</ALIAS>
<ATTRIBUTENAME>OBJECTID</ATTRIBUTENAME>
<ATTRIBUTENO>1</ATTRIBUTENO>
<AUTOKEYNAME />
<CANAUTONUM>0</CANAUTONUM>
<CHANGED>N</CHANGED>
<CLASSNAME />
<COLUMNNAME>OBJECTID</COLUMNNAME>
<COMPLEXEXPRESSION />
<DEFAULTVALUE />
<DOMAINID />
<EAUDITENABLED>0</EAUDITENABLED>
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGENABLED>0</ESIGENABLED>
<HANDLECOLUMNNAME />
<ISLDOWNER>0</ISLDOWNER>
<ISPOSITIVE>0</ISPOSITIVE>
<LENGTH>19</LENGTH>
<LOCALIZABLE>0</LOCALIZABLE>
<MAXATTRIBUTEID>69557</MAXATTRIBUTEID>
<MAXTYPE>BIGINT</MAXTYPE>
<MLINUSE>0</MLINUSE>
<MLSUPPORTED>0</MLSUPPORTED>
<MUSTBE>1</MUSTBE>
<PERSISTENT>1</PERSISTENT>
<PRIMARYKEYCOLSEQ>1</PRIMARYKEYCOLSEQ>
<REMARKS>Objectid</REMARKS>
<REQUIRED>1</REQUIRED>
<RESTRICTED>0</RESTRICTED>
<SAMEASATTRIBUTE />
<SAMEASOBJECT />
<SCALE>0</SCALE>
<SEARCHTYPE>EXACT</SEARCHTYPE>
<SEQUENCENAME>STR_RETAINING_WALLIDSEQ</SEQUENCENAME>
<TEXTDIRECTION />
<TITLE>Objectid</TITLE>
<USERDEFINED>1</USERDEFINED>
</MAXATTRIBUTECFG>
</MAXOBJECTCFG>
BMXAA5617E - When text search is enabled, a language column name must be specified.
psdi.util.MXApplicationException: BMXAA5617E - When text search is enabled, a language column name must be specified.
at psdi.app.configure.MaxObjectCfg.appValidate(MaxObjectCfg.java:566)
at psdi.mbo.Mbo.validate(Mbo.java:4118)
at psdi.app.configure.MaxAttributeCfg.propagate(MaxAttributeCfg.java:1621)
at psdi.app.configure.MaxAttributeCfg.appValidate(MaxAttributeCfg.java:1102)
at psdi.mbo.Mbo.validate(Mbo.java:4118)
at psdi.mbo.MboSet.validate(MboSet.java:4985)
at psdi.app.configure.MaxAttributeCfgSet.validate(MaxAttributeCfgSet.java:1550)
at psdi.app.configure.MaxObjectCfg.appValidate(MaxObjectCfg.java:745)
at psdi.mbo.Mbo.validate(Mbo.java:4118)
at psdi.mbo.MboSet.validate(MboSet.java:4985)
at psdi.mbo.MboSet.validateTransaction(MboSet.java:7372)
at psdi.txn.MXTransactionImpl.validateTransaction(MXTransactionImpl.java:375)
at psdi.txn.MXTransactionImpl.saveTransaction(MXTransactionImpl.java:207)
at psdi.txn.MXTransactionImpl.save(MXTransactionImpl.java:156)
at psdi.iface.mos.MosProcessImpl.save(MosProcessImpl.java:1769)
at psdi.dm.procclass.DMMaxObjProcess.save(DMMaxObjProcess.java:802)
at psdi.iface.mos.MosProcessImpl.processExternalData(MosProcessImpl.java:335)
at psdi.iface.mos.MosProcessImpl.processObjectStructureService(MosProcessImpl.java:208)
at psdi.iface.mic.MicService.processObjectStructureData(MicService.java:1940)
at psdi.iface.mic.MicService.loadData(MicService.java:1725)
at psdi.dm.pkg.DMPackage.deployStagingData(DMPackage.java:1404)
at psdi.dm.pkg.DMPackage.deployPackage(DMPackage.java:713)
at psdi.webclient.beans.dm.DMAppBean.deployPackage(DMAppBean.java:333)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at psdi.webclient.system.session.AsyncProcess.run(AsyncProcess.java:144)
at java.lang.Thread.run(Thread.java:738)
Please advise what else I can look at that is causing my issue.
Thanks,
David Miller
What version and database? There is a known issue on 7.5.0.5 with oracle.
On Jul 3, 2014 2:07 PM, "david_miller_33139@yahoo.com [MAXIMO]" <
MAXIMO@yahoogroups.com> wrote:
>
>
> I am attempting to use Migration Manager to migrate tables from DEV to QA
> environment. I sine scoped it down to do one table. I am getting the above
> error and can not find anything that could be causing it.
>
>
> BMXAA5617E - When text search is enabled, a language column name must be
> specified.
>
>
> The table I am migrating is not Tex Search enabled and none of the columns
> on the table are Search Type TEXT. I have checked that all data is in order
> in all the following tables
>
>
> /***********************************************************************/
> select *
> from "MAXIMO"."MAXATTRIBUTE"
> where objectname like 'STR\_%'ESCAPE '\' and searchtype = 'TEXT';
>
>
> select *
> from "MAXIMO"."MAXATTRIBUTECFG"
> where objectname like 'STR%' and searchtype = 'TEXT';
> /***********************************************************************/
> select *
> from "MAXIMO"."MAXOBJECTCFG"
> where objectname like 'STR\_%'ESCAPE '\';
>
>
> select *
> from "MAXIMO"."MAXOBJECT"
> where objectname like 'STR\_%'ESCAPE '\';
> /***********************************************************************/
>
> select tablename, textsearchenabled, langtablename, langcolumnname,
> islangtable
> from "MAXIMO"."MAXTABLECFG"
> where tablename like 'STR%';
>
>
> select tablename, textsearchenabled, langtablename, langcolumnname,
> islangtable
> from "MAXIMO"."MAXTABLE"
> where tablename like 'STR%';
> /***********************************************************************/
>
>
> Here is the XML of the Error:
>
>
> <MAXOBJECTCFG xmlns="http://www.ibm.com/maximo" action="AddChange">
> <CHANGED>N</CHANGED>
> <CLASSNAME>psdi.pluss.mbo.SDEMboSet</CLASSNAME>
> <DESCRIPTION>GIS Retaining Wall Structures</DESCRIPTION>
> <EAUDITENABLED>0</EAUDITENABLED>
> <EAUDITFILTER />
> <EAUDITTBNAME />
> <ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
> <ESIGFILTER />
> <EXTENDSOBJECT />
> <IMPORTED>0</IMPORTED>
> <INTERNAL>0</INTERNAL>
> <ISAUDITTABLE>0</ISAUDITTABLE>
> <ISVIEW>0</ISVIEW>
> <MAINOBJECT>0</MAINOBJECT>
> <MAXOBJECTID>2057</MAXOBJECTID>
> <OBJECTNAME>STR_RETAINING_WALL</OBJECTNAME>
> <PERSISTENT>1</PERSISTENT>
> <SERVICENAME>CUSTAPP</SERVICENAME>
> <SITEORGTYPE maxvalue="SYSTEM">SYSTEM</SITEORGTYPE>
> <STORAGEPARTITION>MAXDATA</STORAGEPARTITION>
> <TEXTDIRECTION />
> <TEXTSEARCHENABLED>0</TEXTSEARCHENABLED>
> <TRIGROOT>STR_RETAINING_WALL</TRIGROOT>
> <UNIQUECOLUMNNAME>OBJECTID</UNIQUECOLUMNNAME>
> <USERDEFINED>1</USERDEFINED>
> <MAXTABLECFG>
> <ADDROWSTAMP>0</ADDROWSTAMP>
> <ALTIXNAME />
> <CONTENTATTRIBUTE />
> <EAUDITTBNAME />
> <ISAUDITTABLE>0</ISAUDITTABLE>
> <ISLANGTABLE>0</ISLANGTABLE>
> <MAXTABLEID>1430</MAXTABLEID>
> <RESTOREDATA>0</RESTOREDATA>
> <STORAGEPARTITION>MAXDATA</STORAGEPARTITION>
> <TABLENAME>STR_RETAINING_WALL</TABLENAME>
> <TEXTSEARCHENABLED>0</TEXTSEARCHENABLED>
> <TRIGROOT>STR_RETAINING_WALL</TRIGROOT>
> <UNIQUECOLUMNNAME>OBJECTID</UNIQUECOLUMNNAME>
> </MAXTABLECFG>
> <MAXATTRIBUTECFG>
> <ALIAS>MXASSETNUM</ALIAS>
> <ATTRIBUTENAME>MXASSETNUM</ATTRIBUTENAME>
> <ATTRIBUTENO>2</ATTRIBUTENO>
> <AUTOKEYNAME />
> <CANAUTONUM>1</CANAUTONUM>
> <CHANGED>N</CHANGED>
> <CLASSNAME />
> <COLUMNNAME>MXASSETNUM</COLUMNNAME>
> <COMPLEXEXPRESSION />
> <DEFAULTVALUE />
> <DOMAINID />
> <EAUDITENABLED>0</EAUDITENABLED>
> <ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
> <ESIGENABLED>0</ESIGENABLED>
> <HANDLECOLUMNNAME />
> <ISLDOWNER>0</ISLDOWNER>
> <ISPOSITIVE>0</ISPOSITIVE>
> <LENGTH>12</LENGTH>
> <LOCALIZABLE>0</LOCALIZABLE>
> <MAXATTRIBUTEID>69561</MAXATTRIBUTEID>
> <MAXTYPE>UPPER</MAXTYPE>
> <MLINUSE>0</MLINUSE>
> <MLSUPPORTED>0</MLSUPPORTED>
> <MUSTBE>0</MUSTBE>
> <PERSISTENT>1</PERSISTENT>
> <PRIMARYKEYCOLSEQ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:nil="true" />
> <REMARKS>Mxassetnum</REMARKS>
> <REQUIRED>0</REQUIRED>
> <RESTRICTED>0</RESTRICTED>
> <SAMEASATTRIBUTE>ASSETNUM</SAMEASATTRIBUTE>
> <SAMEASOBJECT>ASSET</SAMEASOBJECT>
> <SCALE>0</SCALE>
> <SEARCHTYPE>WILDCARD</SEARCHTYPE>
> <SEQUENCENAME />
> <TEXTDIRECTION />
> <TITLE>Mxassetnum</TITLE>
> <USERDEFINED>1</USERDEFINED>
> </MAXATTRIBUTECFG>
> <MAXATTRIBUTECFG>
> <ALIAS>MXSITEID</ALIAS>
> <ATTRIBUTENAME>MXSITEID</ATTRIBUTENAME>
> <ATTRIBUTENO>3</ATTRIBUTENO>
> <AUTOKEYNAME />
> <CANAUTONUM>0</CANAUTONUM>
> <CHANGED>N</CHANGED>
> <CLASSNAME>psdi.app.site.FldSiteID</CLASSNAME>
> <COLUMNNAME>MXSITEID</COLUMNNAME>
> <COMPLEXEXPRESSION />
> <DEFAULTVALUE />
> <DOMAINID />
> <EAUDITENABLED>0</EAUDITENABLED>
> <ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
> <ESIGENABLED>0</ESIGENABLED>
> <HANDLECOLUMNNAME />
> <ISLDOWNER>0</ISLDOWNER>
> <ISPOSITIVE>0</ISPOSITIVE>
> <LENGTH>8</LENGTH>
> <LOCALIZABLE>0</LOCALIZABLE>
> <MAXATTRIBUTEID>69564</MAXATTRIBUTEID>
> <MAXTYPE>UPPER</MAXTYPE>
> <MLINUSE>0</MLINUSE>
> <MLSUPPORTED>0</MLSUPPORTED>
> <MUSTBE>0</MUSTBE>
> <PERSISTENT>1</PERSISTENT>
> <PRIMARYKEYCOLSEQ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:nil="true" />
> <REMARKS>Mxsiteid</REMARKS>
> <REQUIRED>0</REQUIRED>
> <RESTRICTED>0</RESTRICTED>
> <SAMEASATTRIBUTE>SITEID</SAMEASATTRIBUTE>
> <SAMEASOBJECT>SITE</SAMEASOBJECT>
> <SCALE>0</SCALE>
> <SEARCHTYPE>WILDCARD</SEARCHTYPE>
> <SEQUENCENAME />
> <TEXTDIRECTION />
> <TITLE>Mxsiteid</TITLE>
> <USERDEFINED>1</USERDEFINED>
> </MAXATTRIBUTECFG>
> <MAXATTRIBUTECFG>
> <ALIAS>OBJECTID</ALIAS>
> <ATTRIBUTENAME>OBJECTID</ATTRIBUTENAME>
> <ATTRIBUTENO>1</ATTRIBUTENO>
> <AUTOKEYNAME />
> <CANAUTONUM>0</CANAUTONUM>
> <CHANGED>N</CHANGED>
> <CLASSNAME />
> <COLUMNNAME>OBJECTID</COLUMNNAME>
> <COMPLEXEXPRESSION />
> <DEFAULTVALUE />
> <DOMAINID />
> <EAUDITENABLED>0</EAUDITENABLED>
> <ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
> <ESIGENABLED>0</ESIGENABLED>
> <HANDLECOLUMNNAME />
> <ISLDOWNER>0</ISLDOWNER>
> <ISPOSITIVE>0</ISPOSITIVE>
> <LENGTH>19</LENGTH>
> <LOCALIZABLE>0</LOCALIZABLE>
> <MAXATTRIBUTEID>69557</MAXATTRIBUTEID>
> <MAXTYPE>BIGINT</MAXTYPE>
> <MLINUSE>0</MLINUSE>
> <MLSUPPORTED>0</MLSUPPORTED>
> <MUSTBE>1</MUSTBE>
> <PERSISTENT>1</PERSISTENT>
> <PRIMARYKEYCOLSEQ>1</PRIMARYKEYCOLSEQ>
> <REMARKS>Objectid</REMARKS>
> <REQUIRED>1</REQUIRED>
> <RESTRICTED>0</RESTRICTED>
> <SAMEASATTRIBUTE />
> <SAMEASOBJECT />
> <SCALE>0</SCALE>
> <SEARCHTYPE>EXACT</SEARCHTYPE>
> <SEQUENCENAME>STR_RETAINING_WALLIDSEQ</SEQUENCENAME>
> <TEXTDIRECTION />
> <TITLE>Objectid</TITLE>
> <USERDEFINED>1</USERDEFINED>
> </MAXATTRIBUTECFG>
> </MAXOBJECTCFG>
>
>
>
>
> BMXAA5617E - When text search is enabled, a language column name must be
> specified.
>
> psdi.util.MXApplicationException: BMXAA5617E - When text search is
> enabled, a language column name must be specified.
> at psdi.app.configure.MaxObjectCfg.appValidate(MaxObjectCfg.java:566)
> at psdi.mbo.Mbo.validate(Mbo.java:4118)
> at psdi.app.configure.MaxAttributeCfg.propagate(MaxAttributeCfg.java:1621)
> at
> psdi.app.configure.MaxAttributeCfg.appValidate(MaxAttributeCfg.java:1102)
> at psdi.mbo.Mbo.validate(Mbo.java:4118)
> at psdi.mbo.MboSet.validate(MboSet.java:4985)
> at
> psdi.app.configure.MaxAttributeCfgSet.validate(MaxAttributeCfgSet.java:1550)
>
> at psdi.app.configure.MaxObjectCfg.appValidate(MaxObjectCfg.java:745)
> at psdi.mbo.Mbo.validate(Mbo.java:4118)
> at psdi.mbo.MboSet.validate(MboSet.java:4985)
> at psdi.mbo.MboSet.validateTransaction(MboSet.java:7372)
> at
> psdi.txn.MXTransactionImpl.validateTransaction(MXTransactionImpl.java:375)
> at psdi.txn.MXTransactionImpl.saveTransaction(MXTransactionImpl.java:207)
> at psdi.txn.MXTransactionImpl.save(MXTransactionImpl.java:156)
> at psdi.iface.mos.MosProcessImpl.save(MosProcessImpl.java:1769)
> at psdi.dm.procclass.DMMaxObjProcess.save(DMMaxObjProcess.java:802)
> at
> psdi.iface.mos.MosProcessImpl.processExternalData(MosProcessImpl.java:335)
> at
> psdi.iface.mos.MosProcessImpl.processObjectStructureService(MosProcessImpl.java:208)
>
> at
> psdi.iface.mic.MicService.processObjectStructureData(MicService.java:1940)
> at psdi.iface.mic.MicService.loadData(MicService.java:1725)
> at psdi.dm.pkg.DMPackage.deployStagingData(DMPackage.java:1404)
> at psdi.dm.pkg.DMPackage.deployPackage(DMPackage.java:713)
> at psdi.webclient.beans.dm.DMAppBean.deployPackage(DMAppBean.java:333)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
>
> at java.lang.reflect.Method.invoke(Method.java:611)
> at psdi.webclient.system.session.AsyncProcess.run(AsyncProcess.java:144)
> at java.lang.Thread.run(Thread.java:738)
>
>
>
>
>
> Please advise what else I can look at that is causing my issue.
>
>
> Thanks,
> David Miller
>
>
>
>
>
>
>
Looking for suggestions to search a group within a group to get all the users into VMM. Currently the client has a group “Everyone Group” under the MAXIMOUSERS group.
Excerpt from wimconfig.xml -----
<config:objectClasses>group</config:objectClasses> <config:searchBases>CN=MAXIMOUSERS,OU=Groups,OU=Maximo,DC=xxx,DC=yyy,DC=org</config:searchBases>
<config:ldapEntityTypes name="PersonAccount" searchFilter="(objectclass=Person)">
<config:objectClasses>user</config:objectClasses>
<config:searchBases>OU=Maximo,DC=xxx,DC=yyy,DC=org</config:searchBases>
</config:ldapEntityTypes>
I even added the Nested Groups option.
<config:groupConfiguration>
<config:memberAttributes name="member" objectClass="group" scope="direct"/>
<config:membershipAttribute name="ingroup" scope="nested"/>
</config:groupConfiguration>
------------------------------------------------
The CN=Everyone Group,CN=Users,DC=xxx,DC=yyy,DC=org is under the the MAXMOUSERS group.
Hope this helps.
Sorry..
App Server
IBM WebSphere Application Server 7.0.0.27
Version
IBM Maximo Asset Management 7.5.0.4 Build 20130129-2023 DB Build V7504-00
Tivoli's process automation engine 7.5.0.4 Build 20130129-2023 DB Build V7504-38
IBM Maximo for Service Providers 7.5.1.2 Build 20130520-1027 DB Build V7512-13
IBM Maximo Enterprise Adapter for SAP Applications 7.5.0.1 Build 201203011027 DB Build V7500-06
IBM Maximo Spatial Asset Management 7.5.0.1-20130410-0901 Build 20120714-2208 DB Build V7501-13 HFDB Build HF7501-01
Server OS
Windows Server 2008 R2 6.1 build 7601 Service Pack 1
Server DB
Oracle 11.2 (Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning and Real Application Testing options)
I use this migration object
DMMAXOBJECTCFG
it contains L_xxxx tables maybe thats what you need
Rgds Ian
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: 03 July 2014 22:08
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] BMXAA5617E - When text search is enabled, a language column name must be specified.
I am attempting to use Migration Manager to migrate tables from DEV to QA environment. I sine scoped it down to do one table. I am getting the above error and can not find anything that could be causing it.
BMXAA5617E - When text search is enabled, a language column name must be specified.
The table I am migrating is not Tex Search enabled and none of the columns on the table are Search Type TEXT. I have checked that all data is in order in all the following tables
/***********************************************************************/
select *
from "MAXIMO"."MAXATTRIBUTE"
where objectname like 'STR\_%'ESCAPE '\' and searchtype = 'TEXT';
select *
from "MAXIMO"."MAXATTRIBUTECFG"
where objectname like 'STR%' and searchtype = 'TEXT';
/***********************************************************************/
select *
from "MAXIMO"."MAXOBJECTCFG"
where objectname like 'STR\_%'ESCAPE '\';
select *
from "MAXIMO"."MAXOBJECT"
where objectname like 'STR\_%'ESCAPE '\';
/***********************************************************************/
select tablename, textsearchenabled, langtablename, langcolumnname, islangtable
from "MAXIMO"."MAXTABLECFG"
where tablename like 'STR%';
select tablename, textsearchenabled, langtablename, langcolumnname, islangtable
from "MAXIMO"."MAXTABLE"
where tablename like 'STR%';
/***********************************************************************/
Here is the XML of the Error:
<MAXOBJECTCFG xmlns="http://www.ibm.com/maximo" action="AddChange">
<CHANGED>N</CHANGED>
<CLASSNAME>psdi.pluss.mbo.SDEMboSet</CLASSNAME>
<DESCRIPTION>GIS Retaining Wall Structures</DESCRIPTION>
<EAUDITENABLED>0</EAUDITENABLED>
<EAUDITFILTER />
<EAUDITTBNAME />
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGFILTER />
<EXTENDSOBJECT />
<IMPORTED>0</IMPORTED>
<INTERNAL>0</INTERNAL>
<ISAUDITTABLE>0</ISAUDITTABLE>
<ISVIEW>0</ISVIEW>
<MAINOBJECT>0</MAINOBJECT>
<MAXOBJECTID>2057</MAXOBJECTID>
<OBJECTNAME>STR_RETAINING_WALL</OBJECTNAME>
<PERSISTENT>1</PERSISTENT>
<SERVICENAME>CUSTAPP</SERVICENAME>
<SITEORGTYPE maxvalue="SYSTEM">SYSTEM</SITEORGTYPE>
<STORAGEPARTITION>MAXDATA</STORAGEPARTITION>
<TEXTDIRECTION />
<TEXTSEARCHENABLED>0</TEXTSEARCHENABLED>
<TRIGROOT>STR_RETAINING_WALL</TRIGROOT>
<UNIQUECOLUMNNAME>OBJECTID</UNIQUECOLUMNNAME>
<USERDEFINED>1</USERDEFINED>
<MAXTABLECFG>
<ADDROWSTAMP>0</ADDROWSTAMP>
<ALTIXNAME />
<CONTENTATTRIBUTE />
<EAUDITTBNAME />
<ISAUDITTABLE>0</ISAUDITTABLE>
<ISLANGTABLE>0</ISLANGTABLE>
<MAXTABLEID>1430</MAXTABLEID>
<RESTOREDATA>0</RESTOREDATA>
<STORAGEPARTITION>MAXDATA</STORAGEPARTITION>
<TABLENAME>STR_RETAINING_WALL</TABLENAME>
<TEXTSEARCHENABLED>0</TEXTSEARCHENABLED>
<TRIGROOT>STR_RETAINING_WALL</TRIGROOT>
<UNIQUECOLUMNNAME>OBJECTID</UNIQUECOLUMNNAME>
</MAXTABLECFG>
<MAXATTRIBUTECFG>
<ALIAS>MXASSETNUM</ALIAS>
<ATTRIBUTENAME>MXASSETNUM</ATTRIBUTENAME>
<ATTRIBUTENO>2</ATTRIBUTENO>
<AUTOKEYNAME />
<CANAUTONUM>1</CANAUTONUM>
<CHANGED>N</CHANGED>
<CLASSNAME />
<COLUMNNAME>MXASSETNUM</COLUMNNAME>
<COMPLEXEXPRESSION />
<DEFAULTVALUE />
<DOMAINID />
<EAUDITENABLED>0</EAUDITENABLED>
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGENABLED>0</ESIGENABLED>
<HANDLECOLUMNNAME />
<ISLDOWNER>0</ISLDOWNER>
<ISPOSITIVE>0</ISPOSITIVE>
<LENGTH>12</LENGTH>
<LOCALIZABLE>0</LOCALIZABLE>
<MAXATTRIBUTEID>69561</MAXATTRIBUTEID>
<MAXTYPE>UPPER</MAXTYPE>
<MLINUSE>0</MLINUSE>
<MLSUPPORTED>0</MLSUPPORTED>
<MUSTBE>0</MUSTBE>
<PERSISTENT>1</PERSISTENT>
<PRIMARYKEYCOLSEQ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
<REMARKS>Mxassetnum</REMARKS>
<REQUIRED>0</REQUIRED>
<RESTRICTED>0</RESTRICTED>
<SAMEASATTRIBUTE>ASSETNUM</SAMEASATTRIBUTE>
<SAMEASOBJECT>ASSET</SAMEASOBJECT>
<SCALE>0</SCALE>
<SEARCHTYPE>WILDCARD</SEARCHTYPE>
<SEQUENCENAME />
<TEXTDIRECTION />
<TITLE>Mxassetnum</TITLE>
<USERDEFINED>1</USERDEFINED>
</MAXATTRIBUTECFG>
<MAXATTRIBUTECFG>
<ALIAS>MXSITEID</ALIAS>
<ATTRIBUTENAME>MXSITEID</ATTRIBUTENAME>
<ATTRIBUTENO>3</ATTRIBUTENO>
<AUTOKEYNAME />
<CANAUTONUM>0</CANAUTONUM>
<CHANGED>N</CHANGED>
<CLASSNAME>psdi.app.site.FldSiteID</CLASSNAME>
<COLUMNNAME>MXSITEID</COLUMNNAME>
<COMPLEXEXPRESSION />
<DEFAULTVALUE />
<DOMAINID />
<EAUDITENABLED>0</EAUDITENABLED>
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGENABLED>0</ESIGENABLED>
<HANDLECOLUMNNAME />
<ISLDOWNER>0</ISLDOWNER>
<ISPOSITIVE>0</ISPOSITIVE>
<LENGTH>8</LENGTH>
<LOCALIZABLE>0</LOCALIZABLE>
<MAXATTRIBUTEID>69564</MAXATTRIBUTEID>
<MAXTYPE>UPPER</MAXTYPE>
<MLINUSE>0</MLINUSE>
<MLSUPPORTED>0</MLSUPPORTED>
<MUSTBE>0</MUSTBE>
<PERSISTENT>1</PERSISTENT>
<PRIMARYKEYCOLSEQ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true" />
<REMARKS>Mxsiteid</REMARKS>
<REQUIRED>0</REQUIRED>
<RESTRICTED>0</RESTRICTED>
<SAMEASATTRIBUTE>SITEID</SAMEASATTRIBUTE>
<SAMEASOBJECT>SITE</SAMEASOBJECT>
<SCALE>0</SCALE>
<SEARCHTYPE>WILDCARD</SEARCHTYPE>
<SEQUENCENAME />
<TEXTDIRECTION />
<TITLE>Mxsiteid</TITLE>
<USERDEFINED>1</USERDEFINED>
</MAXATTRIBUTECFG>
<MAXATTRIBUTECFG>
<ALIAS>OBJECTID</ALIAS>
<ATTRIBUTENAME>OBJECTID</ATTRIBUTENAME>
<ATTRIBUTENO>1</ATTRIBUTENO>
<AUTOKEYNAME />
<CANAUTONUM>0</CANAUTONUM>
<CHANGED>N</CHANGED>
<CLASSNAME />
<COLUMNNAME>OBJECTID</COLUMNNAME>
<COMPLEXEXPRESSION />
<DEFAULTVALUE />
<DOMAINID />
<EAUDITENABLED>0</EAUDITENABLED>
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGENABLED>0</ESIGENABLED>
<HANDLECOLUMNNAME />
<ISLDOWNER>0</ISLDOWNER>
<ISPOSITIVE>0</ISPOSITIVE>
<LENGTH>19</LENGTH>
<LOCALIZABLE>0</LOCALIZABLE>
<MAXATTRIBUTEID>69557</MAXATTRIBUTEID>
<MAXTYPE>BIGINT</MAXTYPE>
<MLINUSE>0</MLINUSE>
<MLSUPPORTED>0</MLSUPPORTED>
<MUSTBE>1</MUSTBE>
<PERSISTENT>1</PERSISTENT>
<PRIMARYKEYCOLSEQ>1</PRIMARYKEYCOLSEQ>
<REMARKS>Objectid</REMARKS>
<REQUIRED>1</REQUIRED>
<RESTRICTED>0</RESTRICTED>
<SAMEASATTRIBUTE />
<SAMEASOBJECT />
<SCALE>0</SCALE>
<SEARCHTYPE>EXACT</SEARCHTYPE>
<SEQUENCENAME>STR_RETAINING_WALLIDSEQ</SEQUENCENAME>
<TEXTDIRECTION />
<TITLE>Objectid</TITLE>
<USERDEFINED>1</USERDEFINED>
</MAXATTRIBUTECFG>
</MAXOBJECTCFG>
BMXAA5617E - When text search is enabled, a language column name must be specified.
psdi.util.MXApplicationException: BMXAA5617E - When text search is enabled, a language column name must be specified.
at psdi.app.configure.MaxObjectCfg.appValidate(MaxObjectCfg.java:566)
at psdi.mbo.Mbo.validate(Mbo.java:4118)
at psdi.app.configure.MaxAttributeCfg.propagate(MaxAttributeCfg.java:1621)
at psdi.app.configure.MaxAttributeCfg.appValidate(MaxAttributeCfg.java:1102)
at psdi.mbo.Mbo.validate(Mbo.java:4118)
at psdi.mbo.MboSet.validate(MboSet.java:4985)
at psdi.app.configure.MaxAttributeCfgSet.validate(MaxAttributeCfgSet.java:1550)
at psdi.app.configure.MaxObjectCfg.appValidate(MaxObjectCfg.java:745)
at psdi.mbo.Mbo.validate(Mbo.java:4118)
at psdi.mbo.MboSet.validate(MboSet.java:4985)
at psdi.mbo.MboSet.validateTransaction(MboSet.java:7372)
at psdi.txn.MXTransactionImpl.validateTransaction(MXTransactionImpl.java:375)
at psdi.txn.MXTransactionImpl.saveTransaction(MXTransactionImpl.java:207)
at psdi.txn.MXTransactionImpl.save(MXTransactionImpl.java:156)
at psdi.iface.mos.MosProcessImpl.save(MosProcessImpl.java:1769)
at psdi.dm.procclass.DMMaxObjProcess.save(DMMaxObjProcess.java:802)
at psdi.iface.mos.MosProcessImpl.processExternalData(MosProcessImpl.java:335)
at psdi.iface.mos.MosProcessImpl.processObjectStructureService(MosProcessImpl.java:208)
at psdi.iface.mic.MicService.processObjectStructureData(MicService.java:1940)
at psdi.iface.mic.MicService.loadData(MicService.java:1725)
at psdi.dm.pkg.DMPackage.deployStagingData(DMPackage.java:1404)
at psdi.dm.pkg.DMPackage.deployPackage(DMPackage.java:713)
at psdi.webclient.beans.dm.DMAppBean.deployPackage(DMAppBean.java:333)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at psdi.webclient.system.session.AsyncProcess.run(AsyncProcess.java:144)
at java.lang.Thread.run(Thread.java:738)
Please advise what else I can look at that is causing my issue.
Thanks,
David Miller
GDF SUEZ E&P UK Ltd (Company Number 3386464), registered in England and Wales with a registered office address at: 40 Holborn Viaduct, London, EC1N 2PB.
**************************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
**************************************************************************************************************
Ya, I forgot to mention that I have cloned the DMMAXOBJECT Object Structure and pruned it down to just 3 Objects:
MAXOBJECTCFG
MAXTABLECFG
MAXATTRIBUTECFG
I have this thing as basic as it gets and cannot understand why it will not work. One table with 3 columns and nothing else.
Thanks,
Miller
I had the same error with JOBPLAN (a different issue). Here are my notes how I fixed it:
select objectname, PERSISTENT
from maxobjectcfg
where objectname in
(select objectname from maxattributecfg where SAMEASOBJECT =
'JOBPLAN' and SAMEASATTRIBUTE = 'STATUS')
For each object that is persistent = 1 check to see if the language column is null and if so
set it to 'LANGCODE'.
Hi,
Even we had faced similar issue..
This is what we have done to fix the issue.
1. The issue was coming because the column we are trying to move had a same
as object whose text search check box enabled in the DB config app main tab
eventhough we had none of the attributes search type set as TEXT.
2. The culprit is this check box. Check for all same as object which is
associated with the attribute you are moving, uncheck the check box Text
search enabled.
3. This check box is non persistent attribute in MAXOBJECT table
This happens mostly when you have updated the search type from TEXT to some
other values without changing this check box.
Hope this will help
On 5 July 2014 00:49, rtyshler@hotmail.com [MAXIMO] <MAXIMO@yahoogroups.com>
wrote:
>
>
> I had the same error with JOBPLAN (a different issue). Here are my notes
> how I fixed it:
> select objectname, PERSISTENT
> from maxobjectcfg
> where objectname in
> (select objectname from maxattributecfg where SAMEASOBJECT =
> 'JOBPLAN' and SAMEASATTRIBUTE = 'STATUS')
>
> For each object that is persistent = 1 check to see if the language column
> is null and if so
> set it to 'LANGCODE'.
>
>
>
>
>
--
Yours;
Vijay Kumar Giliyar
This solved the issue.. I removed the SAMEAS attributes and I was able to migrate. Turning off the Text Search on the parent objects was not an option. They are the ASSET and SITE tables that need their Text Search.
Thanks for help and resolution to my issue.
David Miller
There is a known issue with that - we had that problem at one point too.
Shannon Rotz
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com]
Sent: July-03-14 2:08 PM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] BMXAA5617E - When text search is enabled, a language
column name must be specified.
I am attempting to use Migration Manager to migrate tables from DEV to QA
environment. I sine scoped it down to do one table. I am getting the above
error and can not find anything that could be causing it.
BMXAA5617E - When text search is enabled, a language column name must be
specified.
The table I am migrating is not Tex Search enabled and none of the columns
on the table are Search Type TEXT. I have checked that all data is in order
in all the following tables
/***********************************************************************/
select *
from "MAXIMO"."MAXATTRIBUTE"
where objectname like 'STR\_%'ESCAPE '\' and searchtype = 'TEXT';
select *
from "MAXIMO"."MAXATTRIBUTECFG"
where objectname like 'STR%' and searchtype = 'TEXT';
/***********************************************************************/
select *
from "MAXIMO"."MAXOBJECTCFG"
where objectname like 'STR\_%'ESCAPE '\';
select *
from "MAXIMO"."MAXOBJECT"
where objectname like 'STR\_%'ESCAPE '\';
/***********************************************************************/
select tablename, textsearchenabled, langtablename, langcolumnname,
islangtable
from "MAXIMO"."MAXTABLECFG"
where tablename like 'STR%';
select tablename, textsearchenabled, langtablename, langcolumnname,
islangtable
from "MAXIMO"."MAXTABLE"
where tablename like 'STR%';
/***********************************************************************/
Here is the XML of the Error:
<MAXOBJECTCFG xmlns="http://www.ibm.com/maximo" action="AddChange">
<CHANGED>N</CHANGED>
<CLASSNAME>psdi.pluss.mbo.SDEMboSet</CLASSNAME>
<DESCRIPTION>GIS Retaining Wall Structures</DESCRIPTION>
<EAUDITENABLED>0</EAUDITENABLED>
<EAUDITFILTER />
<EAUDITTBNAME />
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGFILTER />
<EXTENDSOBJECT />
<IMPORTED>0</IMPORTED>
<INTERNAL>0</INTERNAL>
<ISAUDITTABLE>0</ISAUDITTABLE>
<ISVIEW>0</ISVIEW>
<MAINOBJECT>0</MAINOBJECT>
<MAXOBJECTID>2057</MAXOBJECTID>
<OBJECTNAME>STR_RETAINING_WALL</OBJECTNAME>
<PERSISTENT>1</PERSISTENT>
<SERVICENAME>CUSTAPP</SERVICENAME>
<SITEORGTYPE maxvalue="SYSTEM">SYSTEM</SITEORGTYPE>
<STORAGEPARTITION>MAXDATA</STORAGEPARTITION>
<TEXTDIRECTION />
<TEXTSEARCHENABLED>0</TEXTSEARCHENABLED>
<TRIGROOT>STR_RETAINING_WALL</TRIGROOT>
<UNIQUECOLUMNNAME>OBJECTID</UNIQUECOLUMNNAME>
<USERDEFINED>1</USERDEFINED>
<MAXTABLECFG>
<ADDROWSTAMP>0</ADDROWSTAMP>
<ALTIXNAME />
<CONTENTATTRIBUTE />
<EAUDITTBNAME />
<ISAUDITTABLE>0</ISAUDITTABLE>
<ISLANGTABLE>0</ISLANGTABLE>
<MAXTABLEID>1430</MAXTABLEID>
<RESTOREDATA>0</RESTOREDATA>
<STORAGEPARTITION>MAXDATA</STORAGEPARTITION>
<TABLENAME>STR_RETAINING_WALL</TABLENAME>
<TEXTSEARCHENABLED>0</TEXTSEARCHENABLED>
<TRIGROOT>STR_RETAINING_WALL</TRIGROOT>
<UNIQUECOLUMNNAME>OBJECTID</UNIQUECOLUMNNAME>
</MAXTABLECFG>
<MAXATTRIBUTECFG>
<ALIAS>MXASSETNUM</ALIAS>
<ATTRIBUTENAME>MXASSETNUM</ATTRIBUTENAME>
<ATTRIBUTENO>2</ATTRIBUTENO>
<AUTOKEYNAME />
<CANAUTONUM>1</CANAUTONUM>
<CHANGED>N</CHANGED>
<CLASSNAME />
<COLUMNNAME>MXASSETNUM</COLUMNNAME>
<COMPLEXEXPRESSION />
<DEFAULTVALUE />
<DOMAINID />
<EAUDITENABLED>0</EAUDITENABLED>
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGENABLED>0</ESIGENABLED>
<HANDLECOLUMNNAME />
<ISLDOWNER>0</ISLDOWNER>
<ISPOSITIVE>0</ISPOSITIVE>
<LENGTH>12</LENGTH>
<LOCALIZABLE>0</LOCALIZABLE>
<MAXATTRIBUTEID>69561</MAXATTRIBUTEID>
<MAXTYPE>UPPER</MAXTYPE>
<MLINUSE>0</MLINUSE>
<MLSUPPORTED>0</MLSUPPORTED>
<MUSTBE>0</MUSTBE>
<PERSISTENT>1</PERSISTENT>
<PRIMARYKEYCOLSEQ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:nil="true" />
<REMARKS>Mxassetnum</REMARKS>
<REQUIRED>0</REQUIRED>
<RESTRICTED>0</RESTRICTED>
<SAMEASATTRIBUTE>ASSETNUM</SAMEASATTRIBUTE>
<SAMEASOBJECT>ASSET</SAMEASOBJECT>
<SCALE>0</SCALE>
<SEARCHTYPE>WILDCARD</SEARCHTYPE>
<SEQUENCENAME />
<TEXTDIRECTION />
<TITLE>Mxassetnum</TITLE>
<USERDEFINED>1</USERDEFINED>
</MAXATTRIBUTECFG>
<MAXATTRIBUTECFG>
<ALIAS>MXSITEID</ALIAS>
<ATTRIBUTENAME>MXSITEID</ATTRIBUTENAME>
<ATTRIBUTENO>3</ATTRIBUTENO>
<AUTOKEYNAME />
<CANAUTONUM>0</CANAUTONUM>
<CHANGED>N</CHANGED>
<CLASSNAME>psdi.app.site.FldSiteID</CLASSNAME>
<COLUMNNAME>MXSITEID</COLUMNNAME>
<COMPLEXEXPRESSION />
<DEFAULTVALUE />
<DOMAINID />
<EAUDITENABLED>0</EAUDITENABLED>
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGENABLED>0</ESIGENABLED>
<HANDLECOLUMNNAME />
<ISLDOWNER>0</ISLDOWNER>
<ISPOSITIVE>0</ISPOSITIVE>
<LENGTH>8</LENGTH>
<LOCALIZABLE>0</LOCALIZABLE>
<MAXATTRIBUTEID>69564</MAXATTRIBUTEID>
<MAXTYPE>UPPER</MAXTYPE>
<MLINUSE>0</MLINUSE>
<MLSUPPORTED>0</MLSUPPORTED>
<MUSTBE>0</MUSTBE>
<PERSISTENT>1</PERSISTENT>
<PRIMARYKEYCOLSEQ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:nil="true" />
<REMARKS>Mxsiteid</REMARKS>
<REQUIRED>0</REQUIRED>
<RESTRICTED>0</RESTRICTED>
<SAMEASATTRIBUTE>SITEID</SAMEASATTRIBUTE>
<SAMEASOBJECT>SITE</SAMEASOBJECT>
<SCALE>0</SCALE>
<SEARCHTYPE>WILDCARD</SEARCHTYPE>
<SEQUENCENAME />
<TEXTDIRECTION />
<TITLE>Mxsiteid</TITLE>
<USERDEFINED>1</USERDEFINED>
</MAXATTRIBUTECFG>
<MAXATTRIBUTECFG>
<ALIAS>OBJECTID</ALIAS>
<ATTRIBUTENAME>OBJECTID</ATTRIBUTENAME>
<ATTRIBUTENO>1</ATTRIBUTENO>
<AUTOKEYNAME />
<CANAUTONUM>0</CANAUTONUM>
<CHANGED>N</CHANGED>
<CLASSNAME />
<COLUMNNAME>OBJECTID</COLUMNNAME>
<COMPLEXEXPRESSION />
<DEFAULTVALUE />
<DOMAINID />
<EAUDITENABLED>0</EAUDITENABLED>
<ENTITYNAME>STR_RETAINING_WALL</ENTITYNAME>
<ESIGENABLED>0</ESIGENABLED>
<HANDLECOLUMNNAME />
<ISLDOWNER>0</ISLDOWNER>
<ISPOSITIVE>0</ISPOSITIVE>
<LENGTH>19</LENGTH>
<LOCALIZABLE>0</LOCALIZABLE>
<MAXATTRIBUTEID>69557</MAXATTRIBUTEID>
<MAXTYPE>BIGINT</MAXTYPE>
<MLINUSE>0</MLINUSE>
<MLSUPPORTED>0</MLSUPPORTED>
<MUSTBE>1</MUSTBE>
<PERSISTENT>1</PERSISTENT>
<PRIMARYKEYCOLSEQ>1</PRIMARYKEYCOLSEQ>
<REMARKS>Objectid</REMARKS>
<REQUIRED>1</REQUIRED>
<RESTRICTED>0</RESTRICTED>
<SAMEASATTRIBUTE />
<SAMEASOBJECT />
<SCALE>0</SCALE>
<SEARCHTYPE>EXACT</SEARCHTYPE>
<SEQUENCENAME>STR_RETAINING_WALLIDSEQ</SEQUENCENAME>
<TEXTDIRECTION />
<TITLE>Objectid</TITLE>
<USERDEFINED>1</USERDEFINED>
</MAXATTRIBUTECFG>
</MAXOBJECTCFG>
BMXAA5617E - When text search is enabled, a language column name must be
specified.
psdi.util.MXApplicationException: BMXAA5617E - When text search is enabled,
a language column name must be specified.
at psdi.app.configure.MaxObjectCfg.appValidate(MaxObjectCfg.java:566)
at psdi.mbo.Mbo.validate(Mbo.java:4118)
at psdi.app.configure.MaxAttributeCfg.propagate(MaxAttributeCfg.java:1621)
at psdi.app.configure.MaxAttributeCfg.appValidate(MaxAttributeCfg.java:1102)
at psdi.mbo.Mbo.validate(Mbo.java:4118)
at psdi.mbo.MboSet.validate(MboSet.java:4985)
at
psdi.app.configure.MaxAttributeCfgSet.validate(MaxAttributeCfgSet.java:1550)
at psdi.app.configure.MaxObjectCfg.appValidate(MaxObjectCfg.java:745)
at psdi.mbo.Mbo.validate(Mbo.java:4118)
at psdi.mbo.MboSet.validate(MboSet.java:4985)
at psdi.mbo.MboSet.validateTransaction(MboSet.java:7372)
at
psdi.txn.MXTransactionImpl.validateTransaction(MXTransactionImpl.java:375)
at psdi.txn.MXTransactionImpl.saveTransaction(MXTransactionImpl.java:207)
at psdi.txn.MXTransactionImpl.save(MXTransactionImpl.java:156)
at psdi.iface.mos.MosProcessImpl.save(MosProcessImpl.java:1769)
at psdi.dm.procclass.DMMaxObjProcess.save(DMMaxObjProcess.java:802)
at
psdi.iface.mos.MosProcessImpl.processExternalData(MosProcessImpl.java:335)
at
psdi.iface.mos.MosProcessImpl.processObjectStructureService(MosProcessImpl.j
ava:208)
at
psdi.iface.mic.MicService.processObjectStructureData(MicService.java:1940)
at psdi.iface.mic.MicService.loadData(MicService.java:1725)
at psdi.dm.pkg.DMPackage.deployStagingData(DMPackage.java:1404)
at psdi.dm.pkg.DMPackage.deployPackage(DMPackage.java:713)
at psdi.webclient.beans.dm.DMAppBean.deployPackage(DMAppBean.java:333)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at psdi.webclient.system.session.AsyncProcess.run(AsyncProcess.java:144)
at java.lang.Thread.run(Thread.java:738)
Please advise what else I can look at that is causing my issue.
Thanks,
David Miller
Glad was able to help.
To: MAXIMO@yahoogroups.com
From: MAXIMO@yahoogroups.com
Date: Mon, 7 Jul 2014 17:08:11 -0700
Subject: Re: [MAXIMO List] BMXAA5617E - When text search is enabled, a language column name must be specified.
This solved the issue.. I removed the SAMEAS attributes and I was able to migrate. Turning off the Text Search on the parent objects was not an option. They are the ASSET and SITE tables that need their Text Search.
Thanks for help and resolution to my issue.
David Miller