Job stuck

  • 12Views
  • Last Post 5 days ago
0
votes
Daniel Kozlowski posted this 2 weeks ago

I have a job stuck for export from bc to a db table

This was recreated since the other one always reported "Column 'PageTitle' cannot be null"

The coludm Page title was changed to allow for null entry and yet the problem remained, not i cannot run the new job at all as it sticks in queued 

Order By: Standard | Newest | Votes
0
votes
Daniel Kozlowski posted this 2 weeks ago

ok so it ran but i get 60 that say pagetitle cannot be null yet the db does allow for it 

 

CREATE TABLE `products_bc_prod` (

  `Id` int(11) NOT NULL,

  `Name` varchar(83) NOT NULL,

  `Type` varchar(8) NOT NULL,

  `Sku` varchar(64) NOT NULL,

  `Description` mediumtext,

  `Weight` decimal(5,2) DEFAULT NULL,

  `Width` decimal(5,2) DEFAULT NULL,

  `Height` decimal(5,2) DEFAULT NULL,

  `Depth` decimal(5,2) DEFAULT NULL,

  `Price` decimal(7,2) DEFAULT NULL,

  `CostPrice` decimal(6,2) DEFAULT NULL,

  `RetailPrice` decimal(7,2) DEFAULT NULL,

  `SalePrice` decimal(7,2) DEFAULT NULL,

  `CalculatedPrice` decimal(7,2) DEFAULT NULL,

  `Categories` varchar(33) NOT NULL,

  `TaxClassId` int(4) DEFAULT NULL,

  `ProductTaxCode` varchar(30) DEFAULT NULL,

  `BrandId` int(11) DEFAULT NULL,

  `InventoryLevel` int(11) DEFAULT NULL,

  `InventoryWarningLevel` int(11) DEFAULT NULL,

  `InventoryTracking` varchar(7) DEFAULT NULL,

  `FixedCostShippingPrice` int(11) DEFAULT NULL,

  `IsFreeShipping` bit(1) DEFAULT NULL,

  `IsVisible` bit(1) DEFAULT NULL,

  `IsFeatured` bit(1) DEFAULT NULL,

  `RelatedProducts` varchar(101) DEFAULT NULL,

  `Warranty` varchar(30) DEFAULT NULL,

  `BinPickingNumber` varchar(30) DEFAULT NULL,

  `LayoutFile` varchar(30) DEFAULT NULL,

  `Upc` varchar(30) DEFAULT NULL,

  `SearchKeywords` varchar(30) DEFAULT NULL,

  `Availability` varchar(9) DEFAULT NULL,

  `AvailabilityDescription` varchar(30) DEFAULT NULL,

  `GiftWrappingOptionsType` varchar(3) DEFAULT NULL,

  `GiftWrappingOptionsList` varchar(30) DEFAULT NULL,

  `SortOrder` int(11) DEFAULT NULL,

  `Condition1` varchar(3) DEFAULT NULL,

  `IsConditionShown` bit(1) DEFAULT NULL,

  `OrderQuantityMinimum` int(11) DEFAULT NULL,

  `OrderQuantityMaximum` int(11) DEFAULT NULL,

  `PageTitle` varchar(75) DEFAULT NULL,

  `MetaKeywords` varchar(1068) DEFAULT NULL,

  `MetaDescription` varchar(255) DEFAULT NULL,

  `ViewCount` int(11) DEFAULT NULL,

  `PreorderReleaseDate` datetime DEFAULT NULL,

  `PreorderMessage` varchar(30) DEFAULT NULL,

  `IsPreorderOnly` bit(1) DEFAULT NULL,

  `IsPriceHidden` bit(1) DEFAULT NULL,

  `PriceHiddenLabel` varchar(30) DEFAULT NULL,

  `CustomUrl_Value` varchar(85) DEFAULT NULL,

  `CustomUrl_IsCustomized` bit(1) DEFAULT NULL,

  `OpenGraphType` varchar(7) DEFAULT NULL,

  `OpenGraphTitle` varchar(30) DEFAULT NULL,

  `OpenGraphDescription` varchar(30) DEFAULT NULL,

  `OpenGraphUseMetaDescription` bit(1) DEFAULT NULL,

  `OpenGraphUseProductName` bit(1) DEFAULT NULL,

  `OpenGraphUseImage` bit(1) DEFAULT NULL,

  `GlobalTradeItemNumber` varchar(30) DEFAULT NULL,

  `ManufacturerPartNumber` varchar(30) DEFAULT NULL,

  `ReviewsRatingSum` int(4) DEFAULT NULL,

  `ReviewsCount` int(4) DEFAULT NULL,

  `TotalSold` int(11) DEFAULT NULL,

  `BaseVariantId` int(11) DEFAULT NULL,

  `DateCreated` datetime NOT NULL,

  `DateModified` datetime NOT NULL,

  `CustomFields` varchar(1678) DEFAULT NULL,

  PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

0
votes
Daniel Kozlowski posted this 2 weeks ago

ok i just reacted another table and taht one works, it must be caching or something

0
votes
Mariia Zaharova posted this 2 weeks ago

Hi Daniel!

 

Glad to see that the issue is resolved. 

Feel free to contact us in case of any further issues.

 

Best regards,

Mariia

0
votes
Daniel Kozlowski posted this 5 days ago

another one stuck 28961718

seems to happen every so often and there is not much I can do to fix it

Close