Job Postings Are Back Up and Running
Yesterday a guy sent me a job description looking for an SAP FI-AA person who also speaks fluent Japanese.
He would have better luck looking for a Unicorn.
So anyway I said I will look around and try to help him out. So I thought this was a great opportunity to post his job on Mapertunity.
There might actually be a Unicorn out there.
So I translated his job description to Japanese and then went to post it so it would be found in Tokyo, the target job location.
I ran into an issue. I discovered the Job posting was not posting.
So I had to trouble shoot the issue.
Was the page sending the form information to the Server? Yes it was.
I was able to echo out what data both the form was sending to the back end server as well as echo out what the server was receiving. So the form was sending the job posting no problem.
Also since this was a live job posting I checked at the top of the page to see if I had enough job credits to post a new job listing. Yes I had 3 free job postings in my account. So no problem there.
So then I said, is our address look up service looking up the Lat and Long for the Japanese address?
I was able to echo out an accurate lat and long from the job posting address. So Check. So far so good.
Finally I had to do a column by column compare of the database write function to the actual columns in the database. If these get out of sync, the data will not post to the data base.
Oh they can get out of sync whenever I change the data model and don’t get all the piece parts updated.
This is what I found, I had 2 extra address fields in my old data model that I no longer have in the live form. And as a result of the mismatch, the database rejected the data upload.
So all I had to do to fix it was to make sure the write software agreed with the database columns and Presto. Back in business.
The map of course was never broken just the new job posting function.
Luckily the job posting function was only down for about 2 hours before I noticed it was not working.
Lead Software Engineer,