Skip to main content

Data Migration

This will include topics related to data migration.

  • 615 Topics
  • 1,521 Replies
615 Topics
Disna Marakkala
Sidekick (Employee)
Disna MarakkalaSidekick (Employee)
asked in Data Migration
DMM Error when updating WORK_SCHED_ASSIGN in the Deployment container

hi All,I can insert or update the schedule in Employee schedule from IFS client , but I can only insert a record in WORK_SCHED_ASSIGN using DMM and update will give an error at the deployment container.My requirement is to use DMM tool to update the schedule from C to B in below IFS window. the CSV file is attached and it looks like : at the deployment container I get below error and the record did not get updated.Method NEW failed : ORA-20110: WorkSchedAssign.INSOVERLAP: Overlapping date intervals. Has anyone used DMM tool to update schedule in WORK_SCHED_ASSIGN?Does anyone know why I am getting below error and how to resolve this?Or is this a limitation in DMM? Thank you! 

1467
C
Do Gooder (Employee)
NiyomalN
Hero (Partner)
NiyomalNHero (Partner)
asked in Data Migration
DB Links creation steps for DMM to work properly

Hi Experts, at the moment we are trying to configure DMM too to do the migration for a new implementation. The customer hosting the 23R1 version on premise and we are having some hard time to get the DB links works for  non production environment. We have setup the Template project in PROD and then created a project based on the template projects. However, not clear about how we can create DB links to add non production environments as connected environments.  can someone help me to find out the proper way of doing it  like what user we need to use here and stuff like that. Kind Regards!Niyomal.

2811
NiyomalN
Hero (Partner)
C
Do Gooder (Partner)
Colin JamesDo Gooder (Partner)
asked in Data Migration
Reset Event Reference Number

Morning everyone. I’m working with 11.3.9 and we are going to archive events out of an existing database to standup a new initiative. I want to reset the starting reference numbers for all event types. I know that the event reference numbers for Problems is determined based on the problem_hk table and that the change_hk table determines the event reference numbers for service requests and changes. The incident_hk is used to determine the incident_id (not the incident rerfernce). I also know that Incident, Task and Decisions are sequential and I would assume use the same table to determine the next reference number.My question is this, what table is used to determine the event reference number of Incident/Task/Decision events.

160
C
Do Gooder (Partner)
K
Do Gooder (Employee)
kzieseDo Gooder (Employee)
asked in Data Migration
DMM column showing as mandatory, why??

Does anyone know of a way to make this column non mandatory in data migration manager?  Not sure why it would be created this way.  I imported the IFS template.  Version is 23R1 

471
M
Hero (Employee)
M
Hero (Customer)
MMcKHero (Customer)
asked in Data Migration
character set for European accents

HiI’m trying to migrate some European addresses which include accents, cedillas and other special characters, for example Île-de-France,  Lérida and straße.I’m using a standalone migration job reading a CSV file (not the Excel add-in).  The characters are displayed correctly in the cs file when viewed in Excel.I’ve tried using the WE8ISO8859P1 character set which I’ve previously used successfully for the degree symbol for temperatures, but the addresses don’t display correctly - Ãle-de-France.Is there a character set which will handle all the main European special characters?Many thanks,Marion

2312
Jens
Hero (Employee)
J
Do Gooder (Partner)
Johannes KopferDo Gooder (Partner)
asked in Data Migration
Excel AddIn in IFS Cloud 23R1 SU5 with Custom Fields

Hey everybody, I am trying to set up an Excel Migration Job for with custom fields. Unfortunately it doesn´t work. Without the CFs I am able to upload data in the master. With the CFs it seems to work (validation and execution works without errors), but the record set doesn´t update. I am curious if someone of you faced the same issue. Name and Cepi have been updated. Validation looks good.After execution it looks also good.The fields in IFS aren´t updated. Without the custom field data is updated.    Thank you in advance, Johannes

31911
Nirogini Janstin
Do Gooder (Employee)
N
Do Gooder (Customer)
Nico13
asked in Data Migration
IFS REST API -- Lobster Middleware

Hi,when sending a HTTP Post request to IFS REST API I get an 400 error as respone.On the IFS Server I see this log message:2023/10/06 06:31:12 [warn] 96#96: *149147568 [lua] cookie.lua:146: bake(): SameSite value must be 'Strict', 'Lax' or 'None' while connecting to upstream, client: x.x.x.x, server: IFS, request: "POST /main/ifsapplications/projection/v1/LocationHandling.svc/LocationSet HTTP/1.1", host: "IFS"The Post request is initiated by our Lobster middleware, using postman everything is working fine. When doing a HTTP Get to request data it is working as epected.Is there some config missing in IFS regarding SameSite cookies or do we have to configure something ob Lobster-side?Thanks,best regards,Nico

2086
hhy38
Superhero (Customer)
N
Do Gooder (Partner)
NishithDasDo Gooder (Partner)
asked in Data Migration
Unable to create customer in Connected Env via Data Migration Manager

Hi,We are deploying customer via DMM onto a connected environment. But we are getting below error. Any idea what permission is missing here. Please note with the same user I am able to create customer manually in the same connected environment Method NEW failed : ORA-20110: CustomerInfo.NOACCESSTOCREATECUSTOMER: You have no permission to create customers of category CustomerORA-06512: at "IFSAPP.ERROR_SYS", line 140ORA-06512: at "IFSAPP.ERROR_SYS", line 354ORA-06512: at "IFSAPP.CUSTOMER_INFO_API", line 2442ORA-06512: at "IFSAPP.CUSTOMER_INFO_API", line 2459ORA-06512: at "IFSAPP.CUSTOMER_INFO_API", line 677 Thanks,Nishith 

2605
L-PINTA
Do Gooder (Customer)
B
Do Gooder (Customer)
bpamlinDo Gooder (Customer)
asked in Data Migration
Invalid data source definition when migrating lobbies from IEE to Aurena

I have a lobby that is working in IEE and returning data. But when migrating from IEE to Aurena. I get an invalid data source definition error. The client type is set to Aurena. IN AURENA IN IEE data source:   Also the elements that are returning data are returning null values. Any ideas why this is?

870
B
Do Gooder (Customer)
L
Do Gooder (Customer)
lgcSandraDo Gooder (Customer)
asked in Data Migration
Data Synchronization

Hi Community. I am having a first look at the Dat Synchronization functionality on IFS Cloud.Documentation is not bad as overview of different aspects, but as a start point, a bit difficult to follow up.Is anyone out there with experience on setting it up, that would be willing to share that knowledge?Thanks for your time!  

611
L
Do Gooder (Customer)
jascoetsee
Do Gooder (Partner)
jascoetseeDo Gooder (Partner)
asked in Data Migration
Data Migration Manager - Define Installed Environment

Hi,I am trying to complete the task to Define Installed Environment after completing the Basic Project Data for a Data migration job. I am however getting the below error; How can I change the Thousand Separator Format value? 

16310
jascoetsee
Do Gooder (Partner)
B
Do Gooder (Customer)
brmoDo Gooder (Customer)
asked in Data Migration
Add a timestamp field

Hello,In order to load data from INVENTORY_TRANSACTION_HIST2 to DW, it took a lot of time, actually using OBJVERSION to load a latest one but still taking 2 hours only for this table. Is is possible to add a timestamp field directly to a view INVENTORY_TRANSACTION_HIST2, and if any information change in a row the timestamp will be updated ? 

832
B
Do Gooder (Customer)
Disna Marakkala
Sidekick (Employee)
Disna MarakkalaSidekick (Employee)
asked in Data Migration
IFS 23R1 DMM - Error when Importing Template Project file

Hi,When importing the template project file for 23R1 I get below error message.  From Background job error textunable to extend index IFSAPP.DAT_TEMPLATE_LOAD_PK by 128 in tablespace IFSAPP_INDEX     ORA-20110: DatFileOperationUtil.ORA-01654Has anyone encounter the same error or can help to resolve this error please?I was using IFS demo environment https://ifs23r1costestlkp.rnd.ifsdevworld.com/  with Alain credentials to import the template project. Thanks!

1472
Disna Marakkala
Sidekick (Employee)
C
Do Gooder (Customer)
CherylLausDo Gooder (Customer)
asked in Data Migration
Data Migration Manager Legacy Table joins

Just starting out with DMM in IFS Cloud 22R2. I need to pull data from two tables into one target table. The documentation indicates how legacy tables are joined is important but gives no information on how to do this.Somehow this worked when there were two legacy tables with the same key simply by identifying the keys on the Legacy Table definitions.In this new situation, there are three tables involved and I need data from tables T1 & T3. T1 and T2 have the same key. I labeled them Key 1 & 2.T2 and T3 are linked by a different field. I tried labeling these as Key 3, but that did not work.Is this possible to do and if so how?  

1808
Nirogini Janstin
Do Gooder (Employee)
S
Do Gooder (Customer)
SPRRAJDo Gooder (Customer)
asked in Data Migration
Data Migration Error

I’m executing a loader job via OnServer route and once I select the file from the SFTP Server, getting an error “Invalid value for property “IntfaceFile””. Any suggestion on the reason of this error and how to fix it.Thanks

2625
D
Hero (Customer)
D
Hero (Customer)
dmanueleHero (Customer)
asked in Data Migration
Invalid or control characters in xml file

I am trying to import supplier records into my IFS8 system using xml files generated by an external system. The xml files are supposed to be using utf-8 encoding. However, because some of the records are generated from Korean and Ukrainian sources, not all the characters are utf-8 despite the xml referencing <?xml version="1.0" encoding="UTF-8"?>. As a result, when the connector reader gets the xml file, it reports:com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.And the file is not processed any further.Sometimes the control characters will clobber the xml tags, which nullifies the entire file structure.Aside from forcing the sender to reformat the data, is there anything I can do in IFS to compensate for the bad characters when the connector reader tries to pick it up?Here is an example of one of the bad xml files opened in notepad++.  

1780
D
Hero (Customer)
B
Hero (Partner)
bytsophanHero (Partner)
asked in Data Migration
ifs data migration excel add in admin login screen

Hi expertsWhen i try to login into the Migration excel add inI always get into this login mask    can i somehow access the system with the migration tool as an admin with the following loginscreen? I allready tried to enter the Admin URL but i always get an error message​​​​ is there a way i can connect with the admin into the migration tool.

1984
B
Hero (Partner)
A
Do Gooder (Partner)
AmineMedDo Gooder (Partner)
asked in Data Migration
Saving data to Multiple tables

Hello,I am using an external Excel/CSV file as a source, imported by the user into a specific IFS repository. After importing and retrieving the data, I need to store it in multiple IFS tables.Could you please provide guidance on how to achieve this?

420
A
Do Gooder (Partner)
P
Hero (Partner)
Priyanka Cecilia VHero (Partner)
asked in Data Migration
Migration Jobs - Service Resource, Resource Connection and Employee Creation

Hello,I’ve created a Migration job for importing new service resources in Cloud. By baseline, while creating a New Service Resource, it automatically creates a Maintenance Employee record and assigns it to the Service Resource created.But while creating a Migration job, the Maintenance Employee record is not created. Also the Resource Connection with the Company and Site are not setup properly.Below is the Method List used to create Service Resources and Connections. What could be the possible reasons? Any inputs would be appreciated.Kind RegardsPriyanka Cecilia

2104
P
Hero (Partner)
D
Sidekick (Employee)
darshanaSidekick (Employee)
asked in Data Migration
download docker container and heml chart for AirGap installation

Any one know how to download docker container and heml chart for AirGap installation for IFSCloud 23R1?Where should i find the “download.sh” file?  ./download.sh -u your_username -p your_password -j jfrog_artifactory_url -r x.y.z --ifs-helm 

361
S
Do Gooder (Employee)
A
Sidekick (Partner)
ArcElhadCSidekick (Partner)
asked in Data Migration
Migration job Based on new service ressource assistant creation

Hello want to build migration job wich based on the service resource assistant creation. The reousrce will be based on existing person and resource group. Is it something we can do by using the API method ? and if yes where i can find list of method of this API or have acces to the view.New service resource creation 

370
A
Sidekick (Partner)
N
Sidekick
Ngerst
asked in Data Migration
Replication Part

I am looking for a way to run a replication job for Inventory Parts from Contract A to Contract B. However, I want to change the value of a few fields when it goes to Contract B. Overall, we are changing to streamline our part creation process and one of the challenges we have faced was trying to replicate 80% of the inventory part into a new contract, but there are few value changes. Example would be Inventory Part Planner 17 for Contract A = Inventory Part Planner 20 for Contract B. Is it possible to change values of certain fields through the replication job? 

1161
EfekanM
Do Gooder (Employee)
M
Do Gooder
melissahankinsDo Gooder
asked in Data Migration
What criteria should businesses consider when choosing a cloud service for their IFS implementation?

Hello IFS Community, I hope you're all doing well. I'm currently in the process of evaluating cloud services for our IFS (Industrial and Financial Systems) implementation, and I wanted to reach out to this knowledgeable community to gather insights and recommendations on the criteria we should consider when making this important decision. Choosing the right cloud service provider is pivotal to the success and efficiency of our IFS deployment. Here are a few questions and criteria I've been pondering: Scalability: How well does the cloud service provider accommodate the scalability needs of IFS as our business grows? What are the options for scaling up or down, and how easy is it to implement these changes?Security and Compliance: What security measures and compliance certifications should we look for to ensure that our sensitive data and operations meet industry standards and regulatory requirements?Performance and Reliability: Can we rely on the cloud service to deliver consistent per

750
M
Do Gooder
Disna Marakkala
Sidekick (Employee)
Disna MarakkalaSidekick (Employee)
asked in Data Migration
DMM- 'Expand Scope by Target Table's References One Level' hangs up - IFS 23R1

HI All,I got the below situation recently for a customer environment in IFS Cloud 23R1. I  had only CUSTOMER_INFO and CUSTOMER_INFO_ADDRESS target tables were marked as ‘In Scope’. When clicked on Expand Scope by Target Table's References One Level, it was taking long time and hung up.Have anyone of you experienced this ?Do you know any particular reason for this and how to overcome this issue?  Thanks in advance!  

572
Disna Marakkala
Sidekick (Employee)
D
Sidekick (Employee)
darshanaSidekick (Employee)
asked in Data Migration
IFSCloud Remote delivery failed

 During the installation of version 1.2.0, we encountered an issue with the delivery process known as the 'Delivery Not in Sequence Error'. It appears that the delivery order was not completed correctly. I have attached a screenshot for further information.  

1311
D
Sidekick (Employee)

Badges

  • 5th Reply
    jnolanhas earned the badge 5th Reply
  • 1st Topic
    IanTinhas earned the badge 1st Topic
  • 5th Reply
    pabdouhas earned the badge 5th Reply
  • 1st Topic
    DMThas earned the badge 1st Topic
  • 1st Reply
    Mike_Phas earned the badge 1st Reply
Show all badges
Terms & ConditionsCookie settings